CMD : SY Z

Need to go a level up on your DB2 skills and learning ? Start with the DSNZPARM's. Quickest way to explore the DSNZPARM setting for your subsystem using CA Platinum :

1) Navigate to the RC/Query Main Menu window in the platinum database administration tool

2) DB2 Object is SY ( System ) and option is Z ( ZPARM )

3) The above would list out the DSNZPARM's as shown below, you need to start somewhere - Why not take them one by one when you find time ?

CMD : LREBIND

What's it like performing a quick REBIND on a plan or a package ? Well, you don't need the JCL these days for performing BINDs or REBIND's. CA Platinum gives you the functionality to perform the same ''online'' . Here is how you do achieve it -

1) Browse your plan or package which has to undergo a REBIND or BIND



2) Type LREBIND/LBIND against the package



3) Input Screen



4) Output Screen



Note : Errors while performing this operation is notified by the batch processor and the action is rolled back - Couldn't ask for a better method to do BIND's & REBIND's

CMD : DISPLAY

How to check the status of the tablespace or index using the DISPLAY command in
CA Database Management Solutions for DB2 for z/OS ?

1. List the tablespace in Platinum using RC query as shown below -


2. Issue the '' DISPLAY '' command against the tablespace -


3. Platinum displays the information on the status of the tablespace. This command is helpful if you do not like swapping screens with DB2 commands and platinum 

Note : By issusing " -DIS DB(DDB00001) SPACE(TST0001) LIMIT(*) " in the DB2 commands the above result can be obtained as well

CMD : SY L

Ever wondered how can you list out the maintenance job details, logs, Job run time, job name for a tablespace present in your subsystem using CA Platinum ? Here are some simple steps that you need to perform to gather information from the DB2 catalog.

1. List the tablespace in Platinum using RC Query as shown below - 


2. Issue the '' SY L '' command against the tablespace -


3. Platinum displays the information from SYSIBM.SYSCOPY table for the tablespace. Press the PF11 key to see more details as per your requirement

If your shop possesses CA Database Management Solutions for DB2 for z/OS then you need not run any queries in SPUFI to analyze maintenance activities on the tablespaces instead you can use the above method to get your work done