I've lost my IFCIDS

Carl Nelson

I've lost my IFCIDS
DB2 v7 for OS/390

My audits of DDL using class 3 failed to produce any IFCIDS 142. However,
my activity was picked up by class 5 (reads). So I know that SMF102's are
getting cut. I also am using the same process and files that create the
class 5 reports (CA-Insight). At the beginning of my alter activity, I
issue a SET CURRENT SQLID command followed by a commit, and then issue all
my alter/create statements immediately after. I do all of this in a single
SPUFI session.
e.g. in a pds file, I have:
SET CURRENT SQID = 'xxxx';
COMMIT:
ALTER TABLE ....;
COMMIT:
All of this is done in one pass.


Question:
Could my alter activity be getting charged to class 7 (assignment of
authorization id) for the leading SET CURRENT SQLID statement?
Because the alter statements continue as the same session of SPUFI, is all
the activity is recorded under the 1st SQL statement executed?
This would mean the COMMIT does not generate a new UOW, only a UOR.



Thanks,
Carl Nelson




CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain confidential
and privileged information or otherwise protected by law. Any unauthorized
review, use, disclosure or distribution is prohibited. If you are not the
intended recipient, please contact the sender by reply e-mail and destroy
all copies of the original message.

---------------------------------------------------------------------------------
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

Richard Humphris

Re: I've lost my IFCIDS
(in response to Carl Nelson)
Hi Carl,

Was audit class 3 started (this class allows 142 records to be cut) and
is the table you are altering being audited? Btw, the cutting of IFCID
142 is unrelated to units-of-work.

The audit class 5 records only tells DB2 to cut ifcid 144 records. So
seeing the 144 records only tells you that SMF probably didn't "lose"
any smf records; but it won't tell you if 142 records should be cut.

You can do a:
-display trace(*)
command to see which trace have been started.

Rich Humphris

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On
Behalf Of Carl Nelson
Sent: Wednesday, January 05, 2005 12:17 PM
To: [login to unmask email]
Subject: [DB2-L] I've lost my IFCIDS


DB2 v7 for OS/390

My audits of DDL using class 3 failed to produce any IFCIDS 142.
However,
my activity was picked up by class 5 (reads). So I know that SMF102's
are
getting cut. I also am using the same process and files that create the
class 5 reports (CA-Insight). At the beginning of my alter activity, I
issue a SET CURRENT SQLID command followed by a commit, and then issue
all
my alter/create statements immediately after. I do all of this in a
single
SPUFI session.
e.g. in a pds file, I have:
SET CURRENT SQID = 'xxxx';
COMMIT:
ALTER TABLE ....;
COMMIT:
All of this is done in one pass.


Question:
Could my alter activity be getting charged to class 7 (assignment of
authorization id) for the leading SET CURRENT SQLID statement?
Because the alter statements continue as the same session of SPUFI, is
all
the activity is recorded under the 1st SQL statement executed?
This would mean the COMMIT does not generate a new UOW, only a UOR.



Thanks,
Carl Nelson




CONFIDENTIALITY NOTICE: This e-mail message, including any attachments,
is for the sole use of the intended recipient(s) and may contain
confidential
and privileged information or otherwise protected by law. Any
unauthorized
review, use, disclosure or distribution is prohibited. If you are not
the
intended recipient, please contact the sender by reply e-mail and
destroy
all copies of the original message.

------------------------------------------------------------------------
---------
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

E-MAIL CONFIDENTIALITY NOTICE: The contents of this e-mail message and any attachments are intended solely for the
addressee(s) and may contain confidential and/or legally privileged information. If you are not the
intended recipient of this message or if this message has been addressed to you in error, please
immediately alert the sender by reply e-mail and then delete this message and any attachments. If you
are not the intended recipient, you are notified that any use, dissemination, distribution, copying, or
storage of this message or any attachment is strictly prohibited.

---------------------------------------------------------------------------------
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