Personal tools
You are here: Home DB2 Mainframe How To's Printing DB2 Admin results
Log in

Forgot your password?
Document Actions

Printing DB2 Admin results

if you need to print the results from a DB2 Admin query

Following is the procedure to follow, if you need to print the results from a DB2 Admin query, such as the listing of table spaces, SM function, and so on:

1 - Using TSO option 3.2 create a sequential data set ( let's assume the name is DBADB2.SPACE.REPORT1)

2 - Using TSO option 6 (for commands) enter the following:

ALLOCATE DDNAME( adminout ) DSN(' ') old reuse


adminout may be any name is the data set created in step 1

3 - Go to DB2ADMIN

4 - Perform your query. One good example is using the SM function described under the DB2 ADMIN - Space Gatherings

5 - When you get the results you want printed enter the following command in the command line:

> PRINT TABLE ON FILE adminout (note the > before the command)

6 - DB2ADMIN will prompt you to select the columns you want printed, so enter S beside the column list for the columns you want printed

7 - Hit enter and the selected columns will have a '*'

8 - Hit F3 and the data set will contain the results.

Note: you have to allocate (step 2) before you go to DB2ADMIN. Note also that the key is leaving the disp of old on the admin print file and not letting it go back to defaults on the DB2 admin profile

Security Awareness
Would you like your company to implement gamification into your security awareness program?