Antwort: [DB2-L] 00c90110 Code

Roy Boxwell

Antwort: [DB2-L] 00c90110 Code
try a REPAIR DBD TEST DATABASE xxxxxxxx and see what it says...

Roy Boxwell
SOFTWARE ENGINEERING GMBH
-Product Development-
Robert-Stolz-Strasse 5
40470 Duesseldorf/Germany
Tel. +49 (0)211 96149-0
Fax +49 (0)211 96149-35
E-mail [login to unmask email]
Homepage www.seg.de





Derek McCoubrey <[login to unmask email]>
Gesendet von: DB2 Data Base Discussion List <[login to unmask email]>
15.12.2006 12:08
Bitte antworten an DB2 Database Discussion list at IDUG


An: [login to unmask email]
Kopie:
Thema: [DB2-L] 00c90110 Code


When trying to do an update on his table our customer got a 00c90110 code.
This was being done via a COBOL program.

He was not declaring a Global Temporary Table as per an IBM APAR and there
does not appear to be a conflict between the catalog and directory.

We have run DSN1COPY (CHECK) and DSN1CHKR and these do not reveal any
problems.

Has anyone had any similar problems or are there any suggestions as to how
we may solve this?

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

Mike Bell

Re: 00c90110 Code
(in response to Roy Boxwell)
How many ways can you get a 00c90110 - more than you can count

Things to check for.
1. DSN1COPY with xlat - make sure that all the rows in the tablespace match
the expected obid's or DSNTIAUL with SELECT * and SYSREC00 dd dummy.
2. Check the plist for the update call. If the program has an
addressablility problem, the plist can be damaged.
3. check for SQL data in LINKAGE section. This requires SQL-INIT-FLAG set
to 0 for every call. yes, it does increase the run time but the alternative
is to move the data to working storage for every SQL operation.
4. REPAIR DBD TEST has been mentioned already.

You don't mention if it happens every time the program runs or which row it
happens on. Is it consistent and just this program? that usually points to a
programmer error in generated plist or linkage section.

Mike
HLS Technologies




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Derek McCoubrey
Sent: Friday, December 15, 2006 5:08 AM
To: [login to unmask email]
Subject: [DB2-L] 00c90110 Code

When trying to do an update on his table our customer got a 00c90110 code.
This was being done via a COBOL program.

He was not declaring a Global Temporary Table as per an IBM APAR and there
does not appear to be a conflict between the catalog and directory.

We have run DSN1COPY (CHECK) and DSN1CHKR and these do not reveal any
problems.

Has anyone had any similar problems or are there any suggestions as to how
we may solve this?

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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


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

Re: 00c90110 Code
(in response to Mike Bell)
1. DSN1COPY with xlax

(will make things run ALOT slower ...)

Chris Hoelscher
IDMS & DB2 Database Administrator
Humana Inc
502-476-2538
[login to unmask email]

The information transmitted is intended only for the person or entity to which it is addressed and may contain CONFIDENTIAL material. If you receive this material/information in error, please contact the sender and delete or destroy the material/information.

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

Derek McCoubrey

Re: 00c90110 Code
(in response to Chris Hoelscher)
Hi Mike,

The program falls over at the same position each time (on the same row).

The updated table is a large tablespace of 254 partitions. The limit key
for the partition in question is " 'xx' '2004' '32' " the previous partition
is " 'xx' '2004' '28' " and the following partition is " 'xx' '2004' '36' ".

Within each partition the data is then divided by Batch Type and Batch Ref.
Other Batch Types and Batch Refs have been updated for partition " 'xx'
'2004' '32' ". Some of these updates have been for '32' and some for the
other values (i.e. 29, 30 and 31).

We have tried REPAIR DBD TEST but the only error we found was on an
unrelated Database within the system!


Derek

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

Derek McCoubrey

Re: 00c90110 Code
(in response to Derek McCoubrey)
Hi Mike,

Going back to your earlier email, confusion reigns here!

With regards to the DSN1COPY with xlat are you saying we should create another Tablespace with the same column defs and run a DSN1COPY with xlat unloading from the offending Partition into the newly created tablespace? I assume the DSN1COPY job will highlight any OBIDs that do not match the xlat values in the DSN1COPY job?

As a side thought, would this problem be resolved if we unloaded the table, dropped the tablespace, recreated and reloaded it? We would use a BMC utility to unload it.

Derek


----- Original Message ----
From: Mike Bell <[login to unmask email]>
To: [login to unmask email]
Sent: Friday, 15 December, 2006 1:51:11 PM
Subject: Re: [DB2-L] 00c90110 Code


How many ways can you get a 00c90110 - more than you can count

Things to check for.
1. DSN1COPY with xlat - make sure that all the rows in the tablespace match
the expected obid's or DSNTIAUL with SELECT * and SYSREC00 dd dummy.
2. Check the plist for the update call. If the program has an
addressablility problem, the plist can be damaged.
3. check for SQL data in LINKAGE section. This requires SQL-INIT-FLAG set
to 0 for every call. yes, it does increase the run time but the alternative
is to move the data to working storage for every SQL operation.
4. REPAIR DBD TEST has been mentioned already.

You don't mention if it happens every time the program runs or which row it
happens on. Is it consistent and just this program? that usually points to a
programmer error in generated plist or linkage section.

Mike
HLS Technologies




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Derek McCoubrey
Sent: Friday, December 15, 2006 5:08 AM
To: [login to unmask email]
Subject: [DB2-L] 00c90110 Code

When trying to do an update on his table our customer got a 00c90110 code.
This was being done via a COBOL program.

He was not declaring a Global Temporary Table as per an IBM APAR and there
does not appear to be a conflict between the catalog and directory.

We have run DSN1COPY (CHECK) and DSN1CHKR and these do not reveal any
problems.

Has anyone had any similar problems or are there any suggestions as to how
we may solve this?

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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


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



___________________________________________________________
All New Yahoo! Mail – Tired of [login to unmask email]@! come-ons? Let our SpamGuard protect you. http://uk.docs.yahoo.com/nowyoucan.html

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

Mike Bell

Re: 00c90110 Code
(in response to Derek McCoubrey)
The main purpose of my email was to try and sort out which of possible
sources of the 00c90110 abend were affecting you.
1. Possible DBD corruption - you can process other rows successfully so for
the minute rule that out. Also REPAIR DBD check doesn't show anything so
another indicator that the problem is elsewhere.
2. Possible program corruption - memory overlay or damaged PLIST. VARCHAR or
LOB's can overflow program specified sizes and create many interesting and
unusual side effects that usually cause abends
3. Possible data corruption - ways to check for data corruption
DSN1COPY with SYSUT2 DD DUMMY and OBIDXLAT and CHECK - see if there are any
data rows that don't match the obid's that you expect.
DSNTIAUL with the same select criteria as the program. You want the data
record after the last one successfully updated by the program. If the
DSNTIAUL runs condition code = 0 and gives you all the rows you expect, then
the database/table is in good shape and the problem is likely to be the
program or DB2.

Notice that I haven't even listed the checks for DB2 code problems, that
requires a PMR and long discussions with DB2 support. And they will ask for
most of the same items I have listed to try and narrow the search.

Mike
HLS Technologies

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of dms worthing
Sent: Thursday, December 21, 2006 11:02 AM
To: [login to unmask email]
Subject: Re: [DB2-L] 00c90110 Code

Hi Mike,

Going back to your earlier email, confusion reigns here!

With regards to the DSN1COPY with xlat are you saying we should create
another Tablespace with the same column defs and run a DSN1COPY with xlat
unloading from the offending Partition into the newly created tablespace? I
assume the DSN1COPY job will highlight any OBIDs that do not match the xlat
values in the DSN1COPY job?

As a side thought, would this problem be resolved if we unloaded the table,
dropped the tablespace, recreated and reloaded it? We would use a BMC
utility to unload it.

Derek


----- Original Message ----
From: Mike Bell <[login to unmask email]>
To: [login to unmask email]
Sent: Friday, 15 December, 2006 1:51:11 PM
Subject: Re: [DB2-L] 00c90110 Code


How many ways can you get a 00c90110 - more than you can count

Things to check for.
1. DSN1COPY with xlat - make sure that all the rows in the tablespace match
the expected obid's or DSNTIAUL with SELECT * and SYSREC00 dd dummy.
2. Check the plist for the update call. If the program has an
addressablility problem, the plist can be damaged.
3. check for SQL data in LINKAGE section. This requires SQL-INIT-FLAG set
to 0 for every call. yes, it does increase the run time but the alternative
is to move the data to working storage for every SQL operation.
4. REPAIR DBD TEST has been mentioned already.

You don't mention if it happens every time the program runs or which row it
happens on. Is it consistent and just this program? that usually points to a
programmer error in generated plist or linkage section.

Mike
HLS Technologies




-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Derek McCoubrey
Sent: Friday, December 15, 2006 5:08 AM
To: [login to unmask email]
Subject: [DB2-L] 00c90110 Code

When trying to do an update on his table our customer got a 00c90110 code.
This was being done via a COBOL program.

He was not declaring a Global Temporary Table as per an IBM APAR and there
does not appear to be a conflict between the catalog and directory.

We have run DSN1COPY (CHECK) and DSN1CHKR and these do not reveal any
problems.

Has anyone had any similar problems or are there any suggestions as to how
we may solve this?

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

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com
< http://www.grisoft.com/ > ).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003


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


________________________________

Inbox full of spam?
<http://us.rd.yahoo.com/mail/uk/taglines/default/nowyoucan/spam_1gb/*http://
us.rd.yahoo.com/evt=40565/*http://uk.docs.yahoo.com/nowyoucan.html> Get
leading spam protection and 1GB storage with All New Yahoo! Mail.
----------------------------------------------------------------------------
----- 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


---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.510 / Virus Database: 307 - Release Date: 8/14/2003

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