How do I expand the size of the CA Sysview for DB2 for z/OS VSAM Linear history files?
search cancel

How do I expand the size of the CA Sysview for DB2 for z/OS VSAM Linear history files?

book

Article ID: 11163

calendar_today

Updated On:

Products

RC Compare for DB2 for z/OS Bind Analyzer for DB2 for z/OS SQL-Ease for DB2 for z/OS SYSVIEW Performance Management Option for DB2 for z/OS Plan Analyzer for DB2 for z/OS Subsystem Analyzer for DB2 for z/OS Database Analyzer for DB2 for z/OS Fast Unload for DB2 for z/OS Fast Check for DB2 for z/OS Fast Index for DB2 for z/OS Rapid Reorg for DB2 for z/OS

Issue/Introduction



I need to expand the size of my CA Sysview for DB2 for z/OS VSAM Linear History files, how can I achieve this?

Environment

Release:
Component: IDB2

Resolution

Run an IDCAMS Define job to create larger Linear VSAM history files.

While the Data Collector (DC) started task is running, run the .SOURCE IDB2UNLD job that calls the IDB2IUFI program.  This will unload the existing history file(s) creating an SMF file.

Finally, run the IDB2IUFI program modifying the parms to load the SMF file back into the newly created history files. 

Examples:

//UNLOAD       EXEC  PGM=IDB2UIFI,REGION=5M,                        
//                          PARM=('/REQ=UNLDHIST,DBSUB=&DBSUB,DBLOC=&DBLOC,',
//                          'REMPOS=&REMEMBR,TESTV=&TESTVER,',              
//                           'UNLD=&UNLOAD,UNLTYP=&UNLDTYP,UNLCHD=&UNLDCHD') 


//HISTLOAD EXEC PGM=IDB2UIFI,REGION=5M,
//                      PARM=('/REQ=LOADHIST,DBSUB=xxxx,DBLOC=xxxxxxxx,',
//                      'REMPOS=YES,CMP=YES')