Is there a way DSNZPARM using db2 trace's - DB2 on OS/390 zOS

[Prem K Mehrotra]

Is there a way to see current settings of DSNZPARM using trace or some
other command. If
yes, what exactly is the command.

I come from Oracle background. In Oracle there is show parameter all
command which can
show all the parameters. I am looking something similar

Prem

[Rudi]

You can call sample stored procedure DSNWZP.
Look at DB2 V7 Install. Guide Document Number GC26-9936-02 2.8.12.15 Job DSNTEJ6Z:
Job DSNTEJ6Z generates a report of current subsystem parameter settings.

A successful execution of DSNTEJ6Z provides a report in the following format:

DSN8ED7: Sample DB2 Configuration Setting Report Generator

Macro Parameter Current Description/ Install Fld
Name Name Setting Install Field Name Panel ID No.
__________________________________________________ __________________
DSN6SYSP AUDITST 0000000000 AUDIT TRACE DSNTIPN 1
DSN6SYSP CONDBAT 0000000064 MAX REMOTE CONNECTED DSNTIPE 4
DSN6SYSP CTHREAD 00030 MAX USERS DSNTIPE 2
DSN6SYSP DLDFREQ 00005 LEVELID UPDATE FREQ DSNTIPL 14
DSN6SYSP PCLOSEN 00005 SWITCH CHKPTS DSNTIPL 12

So long,
Rudi
pr**********@hotmail.com (Prem K Mehrotra) wrote in message news:<43**************************@posting.google. com>...

Is there a way to see current settings of DSNZPARM using trace or some
other command. If
yes, what exactly is the command.

I come from Oracle background. In Oracle there is show parameter all
command which can
show all the parameters. I am looking something similar

Prem