View previous topic :: View next topic
|
Author |
Message |
muthuvel
Active User
Joined: 29 Nov 2005 Posts: 217 Location: Canada
|
|
|
|
Hi,
I am new to creating tables (though i have known it theoretically).I tried creating a table by SPUFIing the below SQL
Code: |
CREATE TABLE MEM_DATA(
MEMBER_ID CHAR(8) NOT NULL,
PROVIDER_ID CHAR(12),
FIRST_NAME CHAR(50),
LAST_NAME CHAR(50),
DATE_OF_SERVICE DATE,
PROCEDURE_CODE CHAR(03),
CONTROL_CODE CHAR(09),
SUFFIX CHAR(03),
ACCOUNT CHAR(05),
PRIMARY KEY(MEMBER_ID)
) IN Database.Table Space; |
It failed with an SQLCODE of -904
Code: |
DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN UNAVAILABLE RESOURCE. REASON 00D70024, TYPE OF RESOURCE 00000220, AND
RESOURCE NAME FWS21129.DSNDBC.DB211291.TS001.I0001.A001
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXICTB SQL PROCEDURE DETECTING ERROR |
I checked the manuals for 00D70024 ,it says
Quote: |
'Ensure that the data set and its pack are available to DB2 and that the data set has not been inadvertently deleted or migrated by any DASD operation. ' |
I am not sure what dataset and its pack are referred to.
Please assist. |
|
Back to top |
|
|
Gnanas N
Active Member
Joined: 06 Sep 2007 Posts: 792 Location: Chennai, India
|
|
|
|
Hi,
I think underlying dataset for your table space/table might be migrated or deleted.
Can you access other tables from this database/table space?
You have to talk with DBA for this. |
|
Back to top |
|
|
Anuj Dhawan
Superior Member
Joined: 22 Apr 2006 Posts: 6250 Location: Mumbai, India
|
|
|
|
Hi,
Getting in contact with DBA should be helpful - at my shop recently, in test region even, developers are no longer allowed to create "test Tables"... |
|
Back to top |
|
|
|