Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - Greg Ira

Pages: [1] 2 3 4 5 6 ... 16
1
z/OS Server / Re: How would multiple segments be opened?
« on: January 30, 2024, 06:52:41 AM »
Would be interesting to see if both SL298 and SL299 were opened at the same time.  Definitely looks like SL299 was opened right after SL297 was closed.  If both were opened simultaneously that would tell me some sort of CMOD hiccup.  If SL298 was opened first maybe something locked it up temporarily?

2
Report Indexing / Re: Posting date issue
« on: September 29, 2022, 09:49:54 AM »
That definitely makes it difficult.  Of course the obvious question is, can the report creator throw something on the first page for you to trigger on?  Not always an option but I've gotten a few developers to do it before.

3
Report Indexing / Re: Posting date issue
« on: September 29, 2022, 09:02:01 AM »
How different are the date locations?  For example are the "thru" dates locations consistent?  Basically I would try making a Trigger 2 which the date would be based off and have it point at blank spaces where there wouldn't be any if it was the date thru date format thus stopping the indexer from trying to pull in the date on those pages.

4
z/OS Server / Re: ARSYSPIN output order doesn't match output queue
« on: August 16, 2022, 09:26:06 AM »
I believe the default for JOBBREAK is True.

5
z/OS Server / Re: OAM database error
« on: August 10, 2022, 08:58:37 AM »
Thanks Ed,
We did try that,  the DBAs failed to get a reorg to work after multiple attempts.  The docs are kept forever so I don't think there would be much space to reclaim anyways.
  I had to roll up my sleeves and restore my DB2 knowledge from my brain archives to dig down and find the issue.  What it looks like happened is when the DBA created the OAM database he created a relatively small simple database, particular the 32K tablespace.  When the users started hammering us with PDFs it filled the 32K table quickly and we hit the 32 dataset limit for the 32K tablespace OSMOTS32.  He repeated the same definition for our second OAM database so that filled up just as fast.
  I ended up having him define the next database using a partitioned tablespace for OSMOTS32 using VSAM extended in the back end and allowing 128 partitions.  Based on my estimates that should get us through a little more than half the year before we need another one.  We can live with that.
Figured I'd update just in case someone else runs into this.

6
z/OS Server / OAM database error
« on: August 09, 2022, 05:06:01 AM »
Anybody run into the following issue with their OAM database?  Sadly, due to circumstances out of our control, we are way out of support on both CMOD and DB2 so we have no help from IBM forthcoming.  Shot in the dark that someone else has run into this.
  We have an instance that is loading a lot of PDFs through a windows loader into our CMOD instance on z/OS.  Everything is going fine until, after only a few weeks and only a few million documents, we hit this:

ARS0430E LOAD40PW OAM Error: ARGMVSST: 0000000b(0000000c-8802fc78) OND.  426
COLL.FOREVER1.SGD4099B.MCDY99(CAA.R7294) OAM OSREQ MSGAREA:  DSNT408I
SQLCODE = -904, ERROR:  UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C900A4, TYPE OF RESOURCE
00000200, AND RESOURCE NAME OBD4099B.OSMOTS32   

DSNT501I  +ONDDODP DSNISGPI RESOURCE UNAVAILABLE  709
           CORRELATION-ID=OND40P                     
           CONNECTION-ID=DB2CALL                     
           LUW-ID=DODP.DODPLU1.DBEDD5A785C4=172377   
           REASON 00C900A4                           
           TYPE 00000200                             
           NAME OBD4099B.OSMOTS32                     

Our DBAs are very inexperienced and have been unable to diagnose the issue.  Our solution was to create a new OAM database which, as mentioned, only lasted a couple weeks and now we find ourselves with the same issue.  Available storage is way more than needed so were having a hard time figuring out why OAM cannot find enough available segment space.  We have a half dozen other instances on our system that have been loading this way for years with no issues.  If anybody has run into something similar I would appreciate it if you could share your findings.

CMOD on z/OS V10.1
DB2 11
z/OS V2.4

7
Report Indexing / Re: PDF Index from FileName
« on: March 22, 2022, 12:03:47 PM »
All ours have indexing of some sort defined.  If you can it probably wouldn't hurt defining a Trigger1 at the very least.

8
Report Indexing / Re: PDF Index from FileName
« on: March 22, 2022, 08:58:21 AM »
Did you try double quotes around the parameters in the -b parameter?  -b "1,BranchCode"   
That's how we have ours working.

9
MP Server / Re: Determine the active segment table being used
« on: December 09, 2021, 06:29:32 AM »
Maybe this will help for starters.  This is for DB2 on z/OS and shows the open segments for all AGs.  shows us % used.

SELECT DATE(CURRENT DATE) AS RUN_DATE FROM ONDDB.ARSUSER     
WHERE USERID LIKE 'ADMIN';                                     
SELECT SUBSTR(A.NAME,1,10) AS APP_GROUP,                       
DECIMAL((DECIMAL(S.INS_ROWS,11,2))/                           
(DECIMAL(S.MAX_ROWS/100.00,11,2)),11,2) PCT_USED,             
SUBSTR(S.TABLE_NAME,1,10) AS TABLE_P,                       
S.AGID, INTEGER(S.MAX_ROWS)                                   
FROM ONDDB.ARSSEG S, ONDDB.ARSAG A                           
WHERE SUBSTR(S.TABLE_NAME,1,2) <> 'SL'                         
AND S.AGID        = A.AGID                                     
AND S.CLOSED_DATE = 0                                         
ORDER BY A.NAME, S.START_DATE DESC;                           

10
Windows Client / Re: Duplicating users
« on: August 26, 2021, 08:15:16 AM »
Can't do it by ARSXML?  That's what I'd normally do.  The concept of adding 800 users manually is painful to me.

11
Report Indexing / Re: Date Format Error
« on: March 02, 2021, 07:15:49 AM »
Since we haven't seen your indexing I would presume that in and around line 59 of your input data the indexer is finding the trigger you based that field off of.  check the definition for that trigger and see if it appears around line 59. eg if the field is set to FIELD1=2,11,10 then look 2 lines up from " 0081  02-" on record # 59.  If your trigger is found there you'll need to find a different trigger to base that date off of.

12
Report Indexing / Re: Date Format Error
« on: February 24, 2021, 06:23:32 AM »
Your field for that index is pulling data from the wrong location on the report.  If it's truly trying to index a date you need to adjust your field parameters pick up that date.  It's clearly pulling a string from a different location and it isn't a date in the format of %d/%m/%Y

13
z/OS Server / Re: Doing a mask change on report retention
« on: December 21, 2020, 06:48:46 AM »
we could use a little more information.  What is the retention of the current OAM?  Will the retention change make it shorter or longer than the current retention?

14
Has anyone checked if your OSMC (OAM Storage Management Cycle) is completing successfully for your OAM storage groups?  OSMC should be running daily and it handles the transitions.  If there is any errors (missing objects, missing directory) the processing ends for that storage group and moves on to the next.  We've discovered in the past a few storage groups that had been erroring out for months and the docs sat on DASD well beyond their transition dates.

15
z/OS Server / Re: OAM Object Name Reference
« on: April 09, 2020, 07:31:45 AM »
ARSEXOAM keeps OAM and your CMOD tables in sync when you have expire by storage manager.  e.g. If you load into an OAM table that expires objects after 1 year when that object is expired by OAM it places an entry, via DB2 trigger, into an OAM_DELETE table.  ARSEXOAM processes that table to clean out any related entries in your ARS tables.

Pages: [1] 2 3 4 5 6 ... 16