Re: DSNIBMCL RESOURCE UNAVAILABLE

Re: DSNIBMCL RESOURCE UNAVAILABLE

 

  

Explanation:
A data set is in a state that is different from what DB2 expects. Possible
causes are:
A data set was deleted and redefined without DB2's knowledge.
A previous DB2 failure involving the data set might have occurred.
This reason code is issued by the following CSECT: DSNIBMCL

User response:
If the code was received while processing a user table, DB2 determined
that the data set is empty. A DROP TABLESPACE statement followed by a
CREATE TABLESPACE statement and a CREATE TABLE statement defines the
dropped table to DB2. Use the IDCAMS LISTCAT for the failing DB2 dataset.
Check the HI-USED-RBA for this dataset; if HI-USED-RBA = 0, the dataset is
empty.If it was received while processing a DB2 catalog or directory, then
recover the object as specified in DB2 Administration Guide in the section
"Recovering Catalog and Directory Objects".
I would imagine the install didn't work properly. Check the output to make
sure all of the files were created without error.
esp do a search on dsnsct02
Good Luck




"Keith D Johnson "
<db2udbdba-ezmlmshield-x17578432.[Email address protected]
22/02/2008 10:31 AM

To
"LazyDBA Discussion" <[Email address protected]
cc

Subject
DSNIBMCL RESOURCE UNAVAILABLE







I'm new to installing DB2 and after starting DB2 V9 on my z/OS 1.7 system
I
received the following error while trying to GRANT SYSADM authority to a
user. Does anyone know which job I should run to define this resource.

DSNT501I -DB1A DSNIBMCL RESOURCE UNAVAILABLE 482
CORRELATION-ID=DB2GRANT
CONNECTION-ID=BATCH
LUW-ID=DB1A.APPLDB1A.C1FC3B2770E8=0
REASON 00C90094
TYPE 00000201
NAME DSNDB01 .DSNSCT02

Regards,

Keith

z/OS SDS(Software Development Services)
Silicon Valley Laboratory, CA
Primary Phone: 408-463-4274
Secondary Phone: 408-404-5697
Fax: 408-239-0813, Pgr:1-408-973-2892
Internet Mail: [Email address protected]
Intranet Mail: [Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



**********************************************************************************
The information contained in or attached to this message is intended only for the people it is addressed to. If you are not the intended recipient, any use, disclosure or copying of this information is unauthorised and prohibited. This information may be confidential or subject to legal privilege.
It is not the expressed view of Medibank Private Limited or any of its subsidiaries unless it is authorised by a person with actual authority.
To the fullest extent allowed by law, Medibank Private cannot accept liability for any virus damage caused by this message.
Medibank Private Limited ABN 47 080 890 259.
***********************************************************************************

DB2 & UDB email list listserv db2-l LazyDBA home page