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]

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

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


premmehrotra@ho tmail.com (Prem K Mehrotra) wrote in message news:<43441e77. 0401011512.1275 5d26@posting.go ogle.com>...[color=blue]
> 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[/color]