z/OS DB2 7.1 DSNL032I message

Chris Bowen

z/OS DB2 7.1 DSNL032I message
Hi all,

Wwhen one of my colleagues attempts to use an ODBC connection I'm getting a

DSNL032I - DSNLIRTR DRDA EXCEPTION CONDITION IN 750
REQUEST FROM REQUESTOR LOCATION=10.9.1.65 FOR THREAD WITH
LUWID=XXXXXXXXXXXXXXXXXXXXXXXXXXXX
REASON=00D3101C
ERROR ID=DSNLIRTR0003
IFCID=0192
SEE TRACE RECORD WITH IFCID SEQUENCE NUMBER=00000001

The trace record should go to where STATS class 4 goes and in our case that
is SMF.

When I go hunting for a record with IFCID 192 in the SMF data (type 100 I
think) it's not there.

Anybody got any idea where my trace record might have gone?

Thanks in advance
Chris Bowen

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steven Lamb

Re: z/OS DB2 7.1 DSNL032I message
(in response to Chris Bowen)
Should that be type 102?
"STATISTICS TRACE IS 102 (DEC) FOR ALL IFCIDS OTHER THAN
0001, 0002, 0202, AND 0230. "

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joel Goldstein

Re: z/OS DB2 7.1 DSNL032I message
(in response to Steven Lamb)
Statistics is type 100.
IFCID's 1 and 2 are part of the Statistics record.
Type 102 is for performance traces.

Regards,
Joel

Joel Goldstein
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

Should that be type 102?
"STATISTICS TRACE IS 102 (DEC) FOR ALL IFCIDS OTHER THAN
0001, 0002, 0202, AND 0230. "

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Steven Lamb

Re: z/OS DB2 7.1 DSNL032I message
(in response to Joel Goldstein)
On Wed, 17 Jan 2007 09:34:38 -0500, Joel Goldstein - Responsive Systems
<[login to unmask email]> wrote:

>Statistics is type 100.
>IFCID's 1 and 2 are part of the Statistics record.
>Type 102 is for performance traces.
>

Joel,

In my DSNWMSGS member in SDSNSAMP (v7) it says

"SM100LEN LENGTH OF SMF RECORD.
SM100SGD SEGMENT DESCRIPTOR FOR VARIABLE BLOCK SPANNED RECORDS.
SM100FLG SYSTEM INDICATOR.
SM100RTY SMF RECORD TYPE:
SM100RTY STATISTICS TRACE IS 100 (DEC) FOR IFCIDS 0001 AND 0002.
SM100RTY OTHER STATISTICS IFCIDS ARE IN SMF 102 RECORDS. "

So IFCID 192 should be SMF type 102 according to me?!

STeve

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Joel Goldstein

z/OS DB2 7.1 DSNL032I message
(in response to Steven Lamb)
Steve,

The IBM docs like MSGS can be rather confusing at times, and this may be related to a lack of space to write
long explanations. Some times they doc is not kept up to date with the real macro expansions.

First, having IFCIDs activated, for example, Accounting class 3, does not automatically externalize all the IFC data.
But many of the IFCs must be specifically started as a performance trace to a specific destination to get the data.
I've never used the 192 record, so I don't know if that is externalized by turning on Statistics trace class 4.

If it is, it will be an smf type 102 record.
If you specifically start a perf trace for it to smf, it will be a type 102 record.

I suggest doing an assembly for DSNDQWIW SUBTYPE=ALL
to see some additional information about the data fields.

Regards,
Joel

Joel Goldstein
Responsive Systems
Buffer Pool Tool for DB2, the worldwide industry standard
Performance software that works......
Predicts Group Buffer Pool performance too!
www.responsivesystems.com
tel. (732) 972-1261
fax.(732) 972-9416

Joel,

In my DSNWMSGS member in SDSNSAMP (v7) it says

"SM100LEN LENGTH OF SMF RECORD.
SM100SGD SEGMENT DESCRIPTOR FOR VARIABLE BLOCK SPANNED RECORDS.
SM100FLG SYSTEM INDICATOR.
SM100RTY SMF RECORD TYPE:
SM100RTY STATISTICS TRACE IS 100 (DEC) FOR IFCIDS 0001 AND 0002.
SM100RTY OTHER STATISTICS IFCIDS ARE IN SMF 102 RECORDS. "

So IFCID 192 should be SMF type 102 according to me?!

STeve

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Chris Bowen

Re: z/OS DB2 7.1 DSNL032I message
(in response to Joel Goldstein)
Joel, Steve,

Thanks for your input.

I will start digging out the SMF102s.

Best regards,
Chris Bowen

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm