SQLCODE -904 during insert

Carlton Enuda

SQLCODE -904 during insert
Hi list,
Attempt to insert a row into a table produces a -904 reason code 200. I
checked the status of the tablespace and it is "A"ctive. I also checked the
status for the table and it is blank (no parent index defined):

(1) The catalog space column for the tablespace is zero '0' and I'll like to
know if perhaps that is the reason for the -904 error I get while trying to
insert into this table?

(2) During load process for the same table, I receive a DSNU012 with return
code = 8. I examine utility output for other error messages but nothing
there could point me to the probable cause. Anybody come across this
problem? Your response will be greatly appreciated.

Carlton



________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com



craig patton

Re: SQLCODE -904 during insert
(in response to Carlton Enuda)
Carlton,

Can you print more of the message?

The '0' in the catalog for space is NOT the cause of your problem. Check
to see how many extents you have for your VSAM file, check the DASD volume
it is allocated to and make sure there is space available for another
extent. Is this STOGROUP or VSAM defined? (A 'Y' in the IMPLICIT column in
SYSTABLESPACE indicates that it was created using a STOGROUP.) If using a
STOGROUP, check that all the volumes have space.

I have found that most problems with a -904 and all objects are in 'normal'
mode, is caused by some sort of space problem for 1 of the VSAM files being
used for either the TS or 1 of the indexes.

HTH,
Craig Patton


>From: Carlton Enuda <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: SQLCODE -904 during insert
>Date: Wed, 2 Aug 2000 11:38:36 EDT
>
>Hi list,
>Attempt to insert a row into a table produces a -904 reason code 200. I
>checked the status of the tablespace and it is "A"ctive. I also checked the
>status for the table and it is blank (no parent index defined):
>
>(1) The catalog space column for the tablespace is zero '0' and I'll like
>to
>know if perhaps that is the reason for the -904 error I get while trying to
>insert into this table?
>
>(2) During load process for the same table, I receive a DSNU012 with return
>code = 8. I examine utility output for other error messages but nothing
>there could point me to the probable cause. Anybody come across this
>problem? Your response will be greatly appreciated.
>
>Carlton
>
>
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
>
>
>

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com



Carlton Enuda

Re: SQLCODE -904 during insert
(in response to craig patton)
Hi Craig,
Thanks for the response. Here's a screen print of the error message:

INSERT INTO PYT.PTMT_CUST_REF (ACCOUNT_ID, ROW_TIMESTAMP)
VALUES('TEST','2000-07-21-03.03.03.000000');
---------+---------+---------+---------+---------+---------+---------+--------
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200, AND
RESOURCE NAME DBPTTMT01 .PTCMT033
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -110 13172746 0 13223106 -974970879 12714050 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9C4C2'
X'C5E32001' X'00C20042' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+--------
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0

Carlton

>From: craig patton <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: SQLCODE -904 during insert
>Date: Wed, 2 Aug 2000 16:08:27 GMT
>
>Carlton,
>
>Can you print more of the message?
>
> The '0' in the catalog for space is NOT the cause of your problem. Check
>to see how many extents you have for your VSAM file, check the DASD volume
>it is allocated to and make sure there is space available for another
>extent. Is this STOGROUP or VSAM defined? (A 'Y' in the IMPLICIT column
>in
>SYSTABLESPACE indicates that it was created using a STOGROUP.) If using a
>STOGROUP, check that all the volumes have space.
>
>I have found that most problems with a -904 and all objects are in 'normal'
>mode, is caused by some sort of space problem for 1 of the VSAM files being
>used for either the TS or 1 of the indexes.
>
>HTH,
>Craig Patton
>
>
>>From: Carlton Enuda <[login to unmask email]>
>>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>>To: [login to unmask email]
>>Subject: SQLCODE -904 during insert
>>Date: Wed, 2 Aug 2000 11:38:36 EDT
>>
>>Hi list,
>>Attempt to insert a row into a table produces a -904 reason code 200. I
>>checked the status of the tablespace and it is "A"ctive. I also checked
>>the
>>status for the table and it is blank (no parent index defined):
>>
>>(1) The catalog space column for the tablespace is zero '0' and I'll like
>>to
>>know if perhaps that is the reason for the -904 error I get while trying
>>to
>>insert into this table?
>>
>>(2) During load process for the same table, I receive a DSNU012 with
>>return
>>code = 8. I examine utility output for other error messages but nothing
>>there could point me to the probable cause. Anybody come across this
>>problem? Your response will be greatly appreciated.
>>
>>Carlton
>>
>>
>>
>>________________________________________________________________________
>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>>
>>
>>
>>
>>
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
>
>
>

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com



Ray H Janes

Re: SQLCODE -904 during insert
(in response to Carlton Enuda)
Take an image copy...c90097 says to do that. Reads will work, but no DML




Carlton Enuda <[login to unmask email]> on 08/02/2000 11:55:48 AM

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

To: [login to unmask email]
cc: (bcc: Ray H Janes/C/Dallas/Mobil-Notes)
Subject: Re: SQLCODE -904 during insert





Hi Craig,
Thanks for the response. Here's a screen print of the error message:

INSERT INTO PYT.PTMT_CUST_REF (ACCOUNT_ID, ROW_TIMESTAMP)
VALUES('TEST','2000-07-21-03.03.03.000000');
---------+---------+---------+---------+---------+---------+---------+--------
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200, AND
RESOURCE NAME DBPTTMT01 .PTCMT033
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -110 13172746 0 13223106 -974970879 12714050 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9C4C2'
X'C5E32001' X'00C20042' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+--------
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0

Carlton

>From: craig patton <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: SQLCODE -904 during insert
>Date: Wed, 2 Aug 2000 16:08:27 GMT
>
>Carlton,
>
>Can you print more of the message?
>
> The '0' in the catalog for space is NOT the cause of your problem. Check
>to see how many extents you have for your VSAM file, check the DASD volume
>it is allocated to and make sure there is space available for another
>extent. Is this STOGROUP or VSAM defined? (A 'Y' in the IMPLICIT column
>in
>SYSTABLESPACE indicates that it was created using a STOGROUP.) If using a
>STOGROUP, check that all the volumes have space.
>
>I have found that most problems with a -904 and all objects are in 'normal'
>mode, is caused by some sort of space problem for 1 of the VSAM files being
>used for either the TS or 1 of the indexes.
>
>HTH,
>Craig Patton
>
>
>>From: Carlton Enuda <[login to unmask email]>
>>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>>To: [login to unmask email]
>>Subject: SQLCODE -904 during insert
>>Date: Wed, 2 Aug 2000 11:38:36 EDT
>>
>>Hi list,
>>Attempt to insert a row into a table produces a -904 reason code 200. I
>>checked the status of the tablespace and it is "A"ctive. I also checked
>>the
>>status for the table and it is blank (no parent index defined):
>>
>>(1) The catalog space column for the tablespace is zero '0' and I'll like
>>to
>>know if perhaps that is the reason for the -904 error I get while trying
>>to
>>insert into this table?
>>
>>(2) During load process for the same table, I receive a DSNU012 with
>>return
>>code = 8. I examine utility output for other error messages but nothing
>>there could point me to the probable cause. Anybody come across this
>>problem? Your response will be greatly appreciated.
>>
>>Carlton
>>
>>
>>
>>________________________________________________________________________
>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>>
>>
>>
>>
>>
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
>
>
>

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com








Roy Bertossi

Re: SQLCODE -904 during insert
(in response to Ray H Janes)
Carlton,

The 200 was probably the resource type - tablespace. The reason code is a 8
digit number.

Roy
----------------------------------------------------------
Roy Bertossi
Abercrombie & Fitch
Senior Database Analyst
(614) 577-6372


|--------+-------------------------->
| | Carlton Enuda |
| | <[login to unmask email]|
| | TMAIL.COM> |
| | Sent by: DB2 |
| | Data Base |
| | Discussion List |
| | <[login to unmask email]>|
| | |
| | |
| | 08/02/00 11:38 |
| | AM |
| | Please respond |
| | to DB2 Data Base|
| | Discussion List |
| | |
|--------+-------------------------->
>----------------------------------------------------------------------------|
| |
| To: [login to unmask email] |
| cc: |
| Subject: SQLCODE -904 during insert |
>----------------------------------------------------------------------------|




Hi list,
Attempt to insert a row into a table produces a -904 reason code 200. I
checked the status of the tablespace and it is "A"ctive. I also checked the
status for the table and it is blank (no parent index defined):

(1) The catalog space column for the tablespace is zero '0' and I'll like to
know if perhaps that is the reason for the -904 error I get while trying to
insert into this table?

(2) During load process for the same table, I receive a DSNU012 with return
code = 8. I examine utility output for other error messages but nothing
there could point me to the probable cause. Anybody come across this
problem? Your response will be greatly appreciated.

Carlton



________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com








Helen Johnson

Re: SQLCODE -904 during insert
(in response to Roy Bertossi)
Here are some possible reasons you need a copy run.

00C90097

Explanation: An attempt was made to allocate to a table space for update
operations. However, the table space was marked as 'image copy' required,
and updates are not allowed. This condition occurs as a result of any of
the following:

Running a REORG LOG NO or LOAD LOG NO utility on the table space
without running a copy that specifies FULL YES.

Execution of a RECOVER utility which specifies the TORBA or TOCOPY
options, without following it with the required COPY utility.

Execution of a -TERM UTILITY command on a COPY utility that failed
during the copy phase or was active in the copy phase. Until the COPY
utility completes, SQL updates are not allowed because the the
integrity of the data would be compromised.

Execution of a MODIFY utility after all back up copies of the table
space or data set were deleted from the SYSCOPY catalog table.



Carlton Enuda wrote:

> Hi Craig,
> Thanks for the response. Here's a screen print of the error message:
>
> INSERT INTO PYT.PTMT_CUST_REF (ACCOUNT_ID, ROW_TIMESTAMP)
> VALUES('TEST','2000-07-21-03.03.03.000000');
> ---------+---------+---------+---------+---------+---------+---------+--------
> DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
> UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200, AND
> RESOURCE NAME DBPTTMT01 .PTCMT033
> DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
> DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
> DSNT416I SQLERRD = -110 13172746 0 13223106 -974970879 12714050 SQL
> DIAGNOSTIC INFORMATION
> DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9C4C2'
> X'C5E32001' X'00C20042' SQL DIAGNOSTIC INFORMATION
> ---------+---------+---------+---------+---------+---------+---------+--------
> DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
> DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
>
> Carlton
>
> >From: craig patton <[login to unmask email]>
> >Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
> >To: [login to unmask email]
> >Subject: Re: SQLCODE -904 during insert
> >Date: Wed, 2 Aug 2000 16:08:27 GMT
> >
> >Carlton,
> >
> >Can you print more of the message?
> >
> > The '0' in the catalog for space is NOT the cause of your problem. Check
> >to see how many extents you have for your VSAM file, check the DASD volume
> >it is allocated to and make sure there is space available for another
> >extent. Is this STOGROUP or VSAM defined? (A 'Y' in the IMPLICIT column
> >in
> >SYSTABLESPACE indicates that it was created using a STOGROUP.) If using a
> >STOGROUP, check that all the volumes have space.
> >
> >I have found that most problems with a -904 and all objects are in 'normal'
> >mode, is caused by some sort of space problem for 1 of the VSAM files being
> >used for either the TS or 1 of the indexes.
> >
> >HTH,
> >Craig Patton
> >
> >
> >>From: Carlton Enuda <[login to unmask email]>
> >>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
> >>To: [login to unmask email]
> >>Subject: SQLCODE -904 during insert
> >>Date: Wed, 2 Aug 2000 11:38:36 EDT
> >>
> >>Hi list,
> >>Attempt to insert a row into a table produces a -904 reason code 200. I
> >>checked the status of the tablespace and it is "A"ctive. I also checked
> >>the
> >>status for the table and it is blank (no parent index defined):
> >>
> >>(1) The catalog space column for the tablespace is zero '0' and I'll like
> >>to
> >>know if perhaps that is the reason for the -904 error I get while trying
> >>to
> >>insert into this table?
> >>
> >>(2) During load process for the same table, I receive a DSNU012 with
> >>return
> >>code = 8. I examine utility output for other error messages but nothing
> >>there could point me to the probable cause. Anybody come across this
> >>problem? Your response will be greatly appreciated.
> >>
> >>Carlton
> >>
> >>
> >>
> >>________________________________________________________________________
> >>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >>
> >>
> >>
> >>
> >>
> >
> >________________________________________________________________________
> >Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
> >
> >
> >
> >
> >
>
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
>



Robert Jans

Re: SQLCODE -904 during insert
(in response to Helen Johnson)
The reason code says an image copy is required.............

******************** Text Below Copyright (c) 2000, IBM *****************

00C90097

Explanation: An attempt was made to allocate to a table space for update
operations. However, the table space was marked as 'image copy' required
and updates are not allowed. This condition occurs as a result of any of
the following:
o Running a REORG LOG NO or LOAD LOG NO utility on the table space
without running a copy that specifies FULL YES.
o Execution of a RECOVER utility which specifies the TORBA or TOCOPY
options, without following it with the required COPY utility.
o Execution of a -TERM UTILITY command on a COPY utility that failed
during the copy phase or was active in the copy phase. Until the COPY
utility completes, SQL updates are not allowed because the the
integrity of the data would be compromised.
o Execution of a MODIFY utility after all back up copies of the table
space or data set were deleted from the SYSCOPY catalog table.

System Action: The allocation process is not allowed.

User Response: Run the COPY utility. However, if the table space is to be
used for read-only access, or if recoverability of the data is not
required, instead of taking a full image copy you can run the REPAIR
utility and request that the image copy required condition be removed.
------------------( Forwarded letter 1 follows )---------------------
Date: Wed, 2 Aug 2000 12:55:48 EDT
To: [login to unmask email]
From: Carlton.Enuda[carltonenuda]@hotmail.com
Sender: [login to unmask email]
Reply-To: DB2.Data.Base.Discussion.List[DB2-L]@RYCI.COM
Subject: Re: SQLCODE -904 during insert

Hi Craig,
Thanks for the response. Here's a screen print of the error message:

INSERT INTO PYT.PTMT_CUST_REF (ACCOUNT_ID, ROW_TIMESTAMP)
VALUES('TEST','2000-07-21-03.03.03.000000');
---------+---------+---------+---------+---------+---------+---------+--------
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90097, TYPE OF RESOURCE 00000200, AND
RESOURCE NAME DBPTTMT01 .PTCMT033
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXRUID SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = -110 13172746 0 13223106 -974970879 12714050 SQL
DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'FFFFFF92' X'00C9000A' X'00000000' X'00C9C4C2'
X'C5E32001' X'00C20042' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+--------
DSNE618I ROLLBACK PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0

Carlton

>From: craig patton <[login to unmask email]>
>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>To: [login to unmask email]
>Subject: Re: SQLCODE -904 during insert
>Date: Wed, 2 Aug 2000 16:08:27 GMT
>
>Carlton,
>
>Can you print more of the message?
>
> The '0' in the catalog for space is NOT the cause of your problem. Check
>to see how many extents you have for your VSAM file, check the DASD volume
>it is allocated to and make sure there is space available for another
>extent. Is this STOGROUP or VSAM defined? (A 'Y' in the IMPLICIT column
>in
>SYSTABLESPACE indicates that it was created using a STOGROUP.) If using a
>STOGROUP, check that all the volumes have space.
>
>I have found that most problems with a -904 and all objects are in 'normal'
>mode, is caused by some sort of space problem for 1 of the VSAM files being
>used for either the TS or 1 of the indexes.
>
>HTH,
>Craig Patton
>
>
>>From: Carlton Enuda <[login to unmask email]>
>>Reply-To: DB2 Data Base Discussion List <[login to unmask email]>
>>To: [login to unmask email]
>>Subject: SQLCODE -904 during insert
>>Date: Wed, 2 Aug 2000 11:38:36 EDT
>>
>>Hi list,
>>Attempt to insert a row into a table produces a -904 reason code 200. I
>>checked the status of the tablespace and it is "A"ctive. I also checked
>>the
>>status for the table and it is blank (no parent index defined):
>>
>>(1) The catalog space column for the tablespace is zero '0' and I'll like
>>to
>>know if perhaps that is the reason for the -904 error I get while trying
>>to
>>insert into this table?
>>
>>(2) During load process for the same table, I receive a DSNU012 with
>>return
>>code = 8. I examine utility output for other error messages but nothing
>>there could point me to the probable cause. Anybody come across this
>>problem? Your response will be greatly appreciated.
>>
>>Carlton
>>
>>
>>
>>________________________________________________________________________
>>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>>
>>
>>
>>
>>
>
>________________________________________________________________________
>Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
>
>
>
>

________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com






[login to unmask email]

SQLCODE -904
(in response to Robert Jans)
DB2 V6.1 OS390

We got the following -904 error recently in our MSTR log.

13:59:29 DSNT501I " DSNILMCL RESOURCE UNAVAILABLE
13:59:29 CORRELATION-ID=PT04S160
13:59:29 CONNECTION-ID=CORTEL
13:59:29 LUW-ID=*
13:59:29 REASON 00C9008E
13:59:29 TYPE 00000302
13:59:29 NAME x .00000834.X'000005'

Can anyone suggest how to translate the Name "x .00000834.x'000005'. I have it partially translated
x is our DB name
00000834 = ????
x'000005' = table space data page (?)

I tried matching 834 to SYSIBM.SYSTABLESPACE.OBID with no luck.

TIA



Missy Case

Re: SQLCODE -904
(in response to Rohn.Solecki@MTS.MB.CA)
Rohn,

Try converting the x .00000834. to Decimal - it worked out to 2100 for
me. That should get you on the right track. Your deadlock may be because
of escalation or utilities, that's usually when I've bothered to notice
that the DBID.OBID were in the messages in my MSTR.

Thanks.
Missy Case
FDR TMDBA
701-275-6358




Rohn.Solecki@
MTS.MB.CA To: [login to unmask email]
Sent by: DB2 cc:
Data Base Subject: SQLCODE -904
Discussion
List
<[login to unmask email]
OM>


12/20/00
02:44 PM
Please
respond to
DB2 Data Base
Discussion
List





DB2 V6.1 OS390

We got the following -904 error recently in our MSTR log.

13:59:29 DSNT501I " DSNILMCL RESOURCE UNAVAILABLE
13:59:29 CORRELATION-ID=PT04S160
13:59:29 CONNECTION-ID=CORTEL
13:59:29 LUW-ID=*
13:59:29 REASON 00C9008E
13:59:29 TYPE 00000302
13:59:29 NAME x .00000834.X'000005'

Can anyone suggest how to translate the Name "x .00000834.x'000005'. I
have it partially translated
x is our DB name
00000834 = ????
x'000005' = table space data page (?)

I tried matching 834 to SYSIBM.SYSTABLESPACE.OBID with no luck.

TIA








Shaun LOMBARD

Re: SQLCODE -904
(in response to Missy Case)
Rohn,

There seems to be some information missing. The TYPE 302 should provide a
Database name . Space name . Page number. Your error message only has two
parts, perhaps a bug. Is your Db2 maintenance current?

Shaun

-----Original Message-----
From: Missy Case [mailto:[login to unmask email]
Sent: Thursday, 21 December 2000 7:58
To: [login to unmask email]
Subject: Re: SQLCODE -904


Rohn,

Try converting the x .00000834. to Decimal - it worked out to 2100 for
me. That should get you on the right track. Your deadlock may be because
of escalation or utilities, that's usually when I've bothered to notice
that the DBID.OBID were in the messages in my MSTR.

Thanks.
Missy Case
FDR TMDBA
701-275-6358




Rohn.Solecki@
MTS.MB.CA To: [login to unmask email]
Sent by: DB2 cc:
Data Base Subject: SQLCODE -904
Discussion
List
<[login to unmask email]
OM>


12/20/00
02:44 PM
Please
respond to
DB2 Data Base
Discussion
List





DB2 V6.1 OS390

We got the following -904 error recently in our MSTR log.

13:59:29 DSNT501I " DSNILMCL RESOURCE UNAVAILABLE
13:59:29 CORRELATION-ID=PT04S160
13:59:29 CONNECTION-ID=CORTEL
13:59:29 LUW-ID=*
13:59:29 REASON 00C9008E
13:59:29 TYPE 00000302
13:59:29 NAME x .00000834.X'000005'

Can anyone suggest how to translate the Name "x .00000834.x'000005'. I
have it partially translated
x is our DB name
00000834 = ????
x'000005' = table space data page (?)

I tried matching 834 to SYSIBM.SYSTABLESPACE.OBID with no luck.

TIA













[login to unmask email]

Re: SQLCODE -904
(in response to Shaun LOMBARD)
Shaun:
The 3 parts are there, I changed the DB name to 'x' (clearly an unclear
choice for the substitution <g>). I just can't figure out how to translate
the Table space portion of the name it gave in the message '00000834',
which is definitely no a table or tablespace name in our system, to the
appropriate text representation.

Missy:
At your suggestion I tried converting 834 from hex to decimal, also got
2100 (decimal), and used that as OBID. Still no luck. But that was no
surprise. If it was hex I would have expected it to be formatted like the
data page number, ie DBNAME .x'00000834'.x'000005'

Thanks





"LOMBARD,Shaun" <[login to unmask email]>@RYCI.COM> on 2000/12/20
03:51:44 PM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Re: SQLCODE -904


Rohn,

There seems to be some information missing. The TYPE 302 should provide a
Database name . Space name . Page number. Your error message only has two
parts, perhaps a bug. Is your Db2 maintenance current?

Shaun

-----Original Message-----
From: Missy Case [mailto:[login to unmask email]
Sent: Thursday, 21 December 2000 7:58
To: [login to unmask email]
Subject: Re: SQLCODE -904

Rohn,

Try converting the x .00000834. to Decimal - it worked out to 2100 for
me. That should get you on the right track. Your deadlock may be because
of escalation or utilities, that's usually when I've bothered to notice
that the DBID.OBID were in the messages in my MSTR.

Thanks.
Missy Case
FDR TMDBA
701-275-6358

Rohn.Solecki@
MTS.MB.CA To: [login to unmask email]

DB2 V6.1 OS390

We got the following -904 error recently in our MSTR log.

13:59:29 DSNT501I " DSNILMCL RESOURCE UNAVAILABLE
13:59:29 CORRELATION-ID=PT04S160
13:59:29 CONNECTION-ID=CORTEL
13:59:29 LUW-ID=*
13:59:29 REASON 00C9008E
13:59:29 TYPE 00000302
13:59:29 NAME x .00000834.X'000005'

Can anyone suggest how to translate the Name "x .00000834.x'000005'. I
have it partially translated
x is our DB name
00000834 = ????
x'000005' = table space data page (?)

I tried matching 834 to SYSIBM.SYSTABLESPACE.OBID with no luck.

TIA
eached at [login to unmask email]



Shaun LOMBARD

Re: SQLCODE -904
(in response to Rohn.Solecki@MTS.MB.CA)
Rohn,

Have you tried looking for the 834 in SYSINDEXES ?

Shaun

-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Thursday, 21 December 2000 9:43
To: [login to unmask email]
Subject: Re: SQLCODE -904


Shaun:
The 3 parts are there, I changed the DB name to 'x' (clearly an unclear
choice for the substitution <g>). I just can't figure out how to translate
the Table space portion of the name it gave in the message '00000834',
which is definitely no a table or tablespace name in our system, to the
appropriate text representation.

Missy:
At your suggestion I tried converting 834 from hex to decimal, also got
2100 (decimal), and used that as OBID. Still no luck. But that was no
surprise. If it was hex I would have expected it to be formatted like the
data page number, ie DBNAME .x'00000834'.x'000005'

Thanks





"LOMBARD,Shaun" <[login to unmask email]>@RYCI.COM> on 2000/12/20
03:51:44 PM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Re: SQLCODE -904


Rohn,

There seems to be some information missing. The TYPE 302 should provide a
Database name . Space name . Page number. Your error message only has two
parts, perhaps a bug. Is your Db2 maintenance current?

Shaun

-----Original Message-----
From: Missy Case [mailto:[login to unmask email]
Sent: Thursday, 21 December 2000 7:58
To: [login to unmask email]
Subject: Re: SQLCODE -904

Rohn,

Try converting the x .00000834. to Decimal - it worked out to 2100 for
me. That should get you on the right track. Your deadlock may be because
of escalation or utilities, that's usually when I've bothered to notice
that the DBID.OBID were in the messages in my MSTR.

Thanks.
Missy Case
FDR TMDBA
701-275-6358

Rohn.Solecki@
MTS.MB.CA To: [login to unmask email]

DB2 V6.1 OS390

We got the following -904 error recently in our MSTR log.

13:59:29 DSNT501I " DSNILMCL RESOURCE UNAVAILABLE
13:59:29 CORRELATION-ID=PT04S160
13:59:29 CONNECTION-ID=CORTEL
13:59:29 LUW-ID=*
13:59:29 REASON 00C9008E
13:59:29 TYPE 00000302
13:59:29 NAME x .00000834.X'000005'

Can anyone suggest how to translate the Name "x .00000834.x'000005'. I
have it partially translated
x is our DB name
00000834 = ????
x'000005' = table space data page (?)

I tried matching 834 to SYSIBM.SYSTABLESPACE.OBID with no luck.

TIA
eached at [login to unmask email]








Piontkowski Michael ML

Re: SQLCODE -904
(in response to Shaun LOMBARD)
Look up the description of the type and format
of the name in the Messages & Codes Appendix B.
TYPE 302 is a table space page. Name is DB.SP.PG
where DB is database name, SP is space name and
PG is hexadecimal page number. Search for 834 in
PSID in SYSTABLSPACE.


Mike Piontkowski
TP&S Technical Maintenance
Voice: +1 302.886.4612
Fax: +1 302.886.4749


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, December 20, 2000 17:43
To: [login to unmask email]
Subject: Re: [DB2-L] SQLCODE -904


Shaun:
The 3 parts are there, I changed the DB name to 'x' (clearly an unclear
choice for the substitution <g>). I just can't figure out how to translate
the Table space portion of the name it gave in the message '00000834',
which is definitely no a table or tablespace name in our system, to the
appropriate text representation.

Missy:
At your suggestion I tried converting 834 from hex to decimal, also got
2100 (decimal), and used that as OBID. Still no luck. But that was no
surprise. If it was hex I would have expected it to be formatted like the
data page number, ie DBNAME .x'00000834'.x'000005'

Thanks





"LOMBARD,Shaun" <[login to unmask email]>@RYCI.COM> on 2000/12/20
03:51:44 PM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Re: SQLCODE -904


Rohn,

There seems to be some information missing. The TYPE 302 should provide a
Database name . Space name . Page number. Your error message only has two
parts, perhaps a bug. Is your Db2 maintenance current?

Shaun

-----Original Message-----
From: Missy Case [mailto:[login to unmask email]
Sent: Thursday, 21 December 2000 7:58
To: [login to unmask email]
Subject: Re: SQLCODE -904

Rohn,

Try converting the x .00000834. to Decimal - it worked out to 2100 for
me. That should get you on the right track. Your deadlock may be because
of escalation or utilities, that's usually when I've bothered to notice
that the DBID.OBID were in the messages in my MSTR.

Thanks.
Missy Case
FDR TMDBA
701-275-6358

Rohn.Solecki@
MTS.MB.CA To: [login to unmask email]

DB2 V6.1 OS390

We got the following -904 error recently in our MSTR log.

13:59:29 DSNT501I " DSNILMCL RESOURCE UNAVAILABLE
13:59:29 CORRELATION-ID=PT04S160
13:59:29 CONNECTION-ID=CORTEL
13:59:29 LUW-ID=*
13:59:29 REASON 00C9008E
13:59:29 TYPE 00000302
13:59:29 NAME x .00000834.X'000005'

Can anyone suggest how to translate the Name "x .00000834.x'000005'. I
have it partially translated
x is our DB name
00000834 = ????
x'000005' = table space data page (?)

I tried matching 834 to SYSIBM.SYSTABLESPACE.OBID with no luck.

TIA
eached at [login to unmask email]








Piontkowski Michael ML

Re: SQLCODE -904
(in response to Piontkowski Michael ML)
Not sure if the 1st attempt worked. Resending...

Look up the description of the type and format
of the name in the Messages & Codes Appendix B.
TYPE 302 is a table space page. Name is DB.SP.PG
where DB is database name, SP is space name and
PG is hexadecimal page number.


Mike Piontkowski
TP&S Technical Maintenance
Voice: +1 302.886.4612
Fax: +1 302.886.4749


-----Original Message-----
From: [login to unmask email] [mailto:[login to unmask email]
Sent: Wednesday, December 20, 2000 17:43
To: [login to unmask email]
Subject: Re: [DB2-L] SQLCODE -904


Shaun:
The 3 parts are there, I changed the DB name to 'x' (clearly an unclear
choice for the substitution <g>). I just can't figure out how to translate
the Table space portion of the name it gave in the message '00000834',
which is definitely no a table or tablespace name in our system, to the
appropriate text representation.

Missy:
At your suggestion I tried converting 834 from hex to decimal, also got
2100 (decimal), and used that as OBID. Still no luck. But that was no
surprise. If it was hex I would have expected it to be formatted like the
data page number, ie DBNAME .x'00000834'.x'000005'

Thanks





"LOMBARD,Shaun" <[login to unmask email]>@RYCI.COM> on 2000/12/20
03:51:44 PM

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

Sent by: DB2 Data Base Discussion List <[login to unmask email]>


To: [login to unmask email]
cc:
Subject: Re: SQLCODE -904


Rohn,

There seems to be some information missing. The TYPE 302 should provide a
Database name . Space name . Page number. Your error message only has two
parts, perhaps a bug. Is your Db2 maintenance current?

Shaun

-----Original Message-----
From: Missy Case [mailto:[login to unmask email]
Sent: Thursday, 21 December 2000 7:58
To: [login to unmask email]
Subject: Re: SQLCODE -904

Rohn,

Try converting the x .00000834. to Decimal - it worked out to 2100 for
me. That should get you on the right track. Your deadlock may be because
of escalation or utilities, that's usually when I've bothered to notice
that the DBID.OBID were in the messages in my MSTR.

Thanks.
Missy Case
FDR TMDBA
701-275-6358

Rohn.Solecki@
MTS.MB.CA To: [login to unmask email]

DB2 V6.1 OS390

We got the following -904 error recently in our MSTR log.

13:59:29 DSNT501I " DSNILMCL RESOURCE UNAVAILABLE
13:59:29 CORRELATION-ID=PT04S160
13:59:29 CONNECTION-ID=CORTEL
13:59:29 LUW-ID=*
13:59:29 REASON 00C9008E
13:59:29 TYPE 00000302
13:59:29 NAME x .00000834.X'000005'

Can anyone suggest how to translate the Name "x .00000834.x'000005'. I
have it partially translated
x is our DB name
00000834 = ????
x'000005' = table space data page (?)

I tried matching 834 to SYSIBM.SYSTABLESPACE.OBID with no luck.

TIA
eached at [login to unmask email]