Reason 00C90101 and Erqual 506E

Bachi Allamsetty

Reason 00C90101 and Erqual 506E
Greetings !

We are using DB2 V6 on OS/390. When we are trying to load a table we are
getting the following error message.

DSNIRCCS DATA IN USE DURING ABEND
REASON 00C90101
ERQUAL 506E
TYPE 00000302
NAME <dbname>.<tsname>.X'00000002'
CONNECTION-ID=UTILITY
CORRELATION-ID=DB2LOADA
LUW-ID=*

This table never had data and this is the first time we are trying put some
data in it. I dropped and recreated the tablespace and table etc, with no
luck. I even tried to creating a new tablespace , again with no luck.

Can someone shed some light on this problem.



Bill (GLIC) Johnson

Re: Reason 00C90101 and Erqual 506E
(in response to Steve Evans)
We have just applied a PTF supplied by IBM to fix a similar problem we were
having. We were receiving 00C90101's when a specific application was trying
to update a partitioning index. Its PTF UQ46912. Might want to look at it as
a possible solution?
Bill Johnson DBA
Allstate Insurance Co.

> -----Original Message-----
> From: Bachi Allamsetty [SMTP:[login to unmask email]
> Sent: Thursday, October 05, 2000 7:23 AM
> To: [login to unmask email]
> Subject: Reason 00C90101 and Erqual 506E
>
> Greetings !
>
> We are using DB2 V6 on OS/390. When we are trying to load a table we are
> getting the following error message.
>
> DSNIRCCS DATA IN USE DURING ABEND
> REASON 00C90101
> ERQUAL 506E
> TYPE 00000302
> NAME <dbname>.<tsname>.X'00000002'
> CONNECTION-ID=UTILITY
> CORRELATION-ID=DB2LOADA
> LUW-ID=*
>
> This table never had data and this is the first time we are trying put
> some
> data in it. I dropped and recreated the tablespace and table etc, with no
> luck. I even tried to creating a new tablespace , again with no luck.
>
> Can someone shed some light on this problem.
>
>
>
>
>



Steve Evans

Re: Reason 00C90101 and Erqual 506E
(in response to Bachi Allamsetty)
bachi,

is this a large ts (ie each part > 4 gig) ?.

if so you may have encountered the db2 bug that we hit. ibm coded a patch for us in less that 24 hrs - that's great service.

see apar pq42010.

if u need more info, let meknow.

good luck,

steve


Bachi Allamsetty wrote:

> Greetings !
>
> We are using DB2 V6 on OS/390. When we are trying to load a table we are
> getting the following error message.
>
> DSNIRCCS DATA IN USE DURING ABEND
> REASON 00C90101
> ERQUAL 506E
> TYPE 00000302
> NAME <dbname>.<tsname>.X'00000002'
> CONNECTION-ID=UTILITY
> CORRELATION-ID=DB2LOADA
> LUW-ID=*
>
> This table never had data and this is the first time we are trying put some
> data in it. I dropped and recreated the tablespace and table etc, with no
> luck. I even tried to creating a new tablespace , again with no luck.
>
> Can someone shed some light on this problem.
>
>
>



[login to unmask email]

00c90101
(in response to Bill (GLIC) Johnson)
I previously wrote about a problem with s0c7 abends in SPUFI when trying to
read some tables in db2 v6.1 for os390. There is a ptf that we need to apply
to fix this, but it will take awhile. In the meantime I found a way around.
All the tables in question have a timestamp column. By updating the timestamp
to the current timestamp (which is not a problem in this case) I was able to
make the tables available for viewing. However 3 of my tables I was unable to
update. The error message 00c90101 came back with the unavailable resource
being the table space page. My questions are:

1) Is there a way to resolve the resource unavailable?
2) My other option would be to delete all the data in the tables (only a few
hundred to a few thousand) and then insert from a copy of the database that I
created form the original except using the current timestamp. But will that
fix it or do I need to drop the table first instead of just deleting the data?
TIA
Bud



Martin W - CNF Killen

Re: 00c90101
(in response to Bud.Greenman@ONONDAGA.NY.US)
We have found that a reorg will usually correct the 00c90101.

HTH
Marty.

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Monday, December 18, 2000 8:43 AM
To: [login to unmask email]
Subject: 00c90101


I previously wrote about a problem with s0c7 abends in SPUFI when trying to
read some tables in db2 v6.1 for os390. There is a ptf that we need to
apply
to fix this, but it will take awhile. In the meantime I found a way around.
All the tables in question have a timestamp column. By updating the
timestamp
to the current timestamp (which is not a problem in this case) I was able to
make the tables available for viewing. However 3 of my tables I was unable
to
update. The error message 00c90101 came back with the unavailable resource
being the table space page. My questions are:

1) Is there a way to resolve the resource unavailable?
2) My other option would be to delete all the data in the tables (only a few
hundred to a few thousand) and then insert from a copy of the database that
I
created form the original except using the current timestamp. But will that
fix it or do I need to drop the table first instead of just deleting the
data?
TIA
Bud








Aldrin Jayatilaka

Re: 00c90101
(in response to Martin W - CNF Killen)
00C90101 problem with DB2 v6.1 can also be caused by a BUG with BMC's Reorg
Plus v 5.3.01 which is ment to be DB2 v6 tolerant.

If you are using BMC's Reorg Plus you might want to check this problem out.
You can search for the problem (Failure ID: 61422) at the BMC web site for
further details. This problem can be resolved by running an IBM reorg on
the effected indexes.

regards,

Aldrin Jayatilaka
Database Administrator
IBM Global Services Australia
Phone: +61-2 6124 6107


[login to unmask email] on 19/12/2000 03:42:42 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Aldrin Jayatilaka/Australia/IBM)
Subject: 00c90101




I previously wrote about a problem with s0c7 abends in SPUFI when trying to
read some tables in db2 v6.1 for os390. There is a ptf that we need to
apply
to fix this, but it will take awhile. In the meantime I found a way
around.
All the tables in question have a timestamp column. By updating the
timestamp
to the current timestamp (which is not a problem in this case) I was able
to
make the tables available for viewing. However 3 of my tables I was unable
to
update. The error message 00c90101 came back with the unavailable
resource
being the table space page. My questions are:

1) Is there a way to resolve the resource unavailable?
2) My other option would be to delete all the data in the tables (only a
few
hundred to a few thousand) and then insert from a copy of the database that
I
created form the original except using the current timestamp. But will
that
fix it or do I need to drop the table first instead of just deleting the
data?
TIA
Bud








Mohammed Ahmed

Re: 00c90101
(in response to Aldrin Jayatilaka)
Running Rebuild Index and Check Index hopefully will take care of this
problem.

----------
From: aldrinj
Sent: Monday, December 18, 2000 2:58 PM
To: DB2-L
Cc: aldrinj
Subject: Re: 00c90101

00C90101 problem with DB2 v6.1 can also be caused by a BUG with BMC's
Reorg
Plus v 5.3.01 which is ment to be DB2 v6 tolerant.

If you are using BMC's Reorg Plus you might want to check this
problem out.
You can search for the problem (Failure ID: 61422) at the BMC web
site for
further details. This problem can be resolved by running an IBM
reorg on
the effected indexes.

regards,

Aldrin Jayatilaka
Database Administrator
IBM Global Services Australia
Phone: +61-2 6124 6107


[login to unmask email] on 19/12/2000 03:42:42 AM

Please respond to DB2 Data Base Discussion List <[login to unmask email]>

To: [login to unmask email]
cc: (bcc: Aldrin Jayatilaka/Australia/IBM)
Subject: 00c90101




I previously wrote about a problem with s0c7 abends in SPUFI when
trying to
read some tables in db2 v6.1 for os390. There is a ptf that we need
to
apply
to fix this, but it will take awhile. In the meantime I found a way
around.
All the tables in question have a timestamp column. By updating the
timestamp
to the current timestamp (which is not a problem in this case) I was
able
to
make the tables available for viewing. However 3 of my tables I was
unable
to
update. The error message 00c90101 came back with the unavailable
resource
being the table space page. My questions are:

1) Is there a way to resolve the resource unavailable?
2) My other option would be to delete all the data in the tables
(only a
few
hundred to a few thousand) and then insert from a copy of the
database that
I
created form the original except using the current timestamp. But
will
that
fix it or do I need to drop the table first instead of just deleting
the
data?
TIA
Bud



visit
the DB2-L webpage at http://www.ryci.com/db2-l. The owners of the
list can




visit the DB2-L webpage at http://www.ryci.com/db2-l. The owners of
the list can



Mohammed Nayeem

Re: 00c90101
(in response to Mohammed Ahmed)
But if Tablespace is in RECP then first run RECOVER then REBUILD , CHECK
INDEX , CHECK DATA respectively.

Thanks
Nayeem