Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

RACF problem creating a DB2 table

545 views
Skip to first unread message

George G. White

unread,
Jan 26, 1999, 3:00:00 AM1/26/99
to
I attempt to create a new table under TSO/SPUFI as follows with the
following results.
The problem seems to be some form of RACF requirement that I do not
have. Can any one
tell me what form of permission I need to allocate the new file? I am
logged on as IBMUSER
on a PC server 500 system running OS390 version 5.2 and DB2 version 5.1.

The SPUFI input and error messages follow. and the console messages are
listed after the
SPUFI input and output.

SPUFI input is:
---------+---------+---------+---------+---------+---------+---------+---------+

CREATE TABLE RCMTABLE
( RCMACCNT VARCHAR(40) NOT NULL,
RCMDEBIT CHAR(4) NOT NULL,
RCMTRAN# INTEGER,
RCMINDATE DATE,
RCMSDATE DATE,
RCMEDATE DATE,
RCMUDATE DATE,
RCMUSER VARCHAR(40),
RCMUNITS INTEGER,
RCMCHARGE DEC(9,2),
RCMSTAT VARCHAR(10),
RCMDBCR CHAR(1),
RCMCOMNT VARCHAR(100),
PRIMARY KEY(RCMACCNT));
---------+---------+---------+---------+---------+---------+---------+---------+

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00D70025, TYPE OF RESOURCE
00000220, AND
RESOURCE NAME DSN510.DSNDBC.DSNDB04.RCMTABLE.I0001.A001
DSNT418I SQLSTATE = 57011 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXICTS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 105 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000069' X'00000000' X'00000000' X'FFFFFFFF'

X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION

****************************************************
My comments
Master console has the following messages:
****************************************************
DSN510.DSNDBC.DSNDB04.RCMTABLE.I0001.A001 CL(DATASET ) VOL(P390DX)
DEFINE - INSUFFICIENT AUTHORITY
DSNP009I - THE FOLLOWING ERROR MESSAGES WERE RECEIVED 551
FOR DEFINE CLUSTER ON DSN510.DSNDBC.DSNDB04.RCMTABLE.I0001.A001
IDC3036I DATA SET COULD NOT BE DEFINED TO SECURITY SUBSYSTEM
IDC3009I ** VSAM CATALOG RETURN CODE IS 118 - REASON CODE IS
IGG0CLFT-0
IDC3003I FUNCTION TERMINATED. CONDITION CODE IS 12

DSNP010I - END OF MESSAGES. 552
CONNECTION-ID=TSO
CORRELATION-ID=IBMUSER
LUW-ID=*
DSNP002I - DSNPDFN1 - DEFINE FAILED FOR 553
DSN510.DSNDBC.DSNDB04.RCMTABLE.I0001.A001.
RC=00D70025
CONNECTION-ID=TSO, CORRELATION-ID=IBMUSER,
LUW-ID=*
DSNP016I - DSNPCPS0 - CREATE FAILED FOR 554
DSNDB04.RCMTABLE.I0001.
RC=00D70025
CONNECTION-ID=TSO, CORRELATION-ID=IBMUSER,
LUW-ID=*

0 new messages