How to create a DB2 tablespace using spufi???

sreenath.yettapu · Posted: Thu Feb 10, 2011 9:51 am

Hi,

I am trying to create my own database, storage group and tablespace using the following query in SPUFI. But I am facing problem with tablespace creation query. Can anyone please guide me?

Thanks in Advance..

Query:
CREATE DATABASE DBS2302 STOGROUP STGS2302;
---------+---------+---------+---------+---------+---------+
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+

CREATE TABLESPACE TSS2302 IN DBS2302
USING STOGROUP STGS2302
BUFFERPOOL BP0;
---------+---------+---------+---------+---------+---------+---------+--
DSNT408I SQLCODE = -204, ERROR: STGS2302 IS AN UNDEFINED NAME
DSNT418I SQLSTATE = 42704 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNXISUB SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 40 0 0 -1 0 0 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000028' X'00000000' X'00000000' X'FFFFFFFF'
X'00000000' X'00000000' SQL DIAGNOSTIC INFORMATION
---------+---------+---------+---------+---------+---------+---------+--

dbzTHEdinosauer · Posted: Thu Feb 10, 2011 12:09 pm

you probably have to qualify the storage group name,
since under spufi,
you are running with your userid as creator.

easiest way to find out is look at the sysibm. table that lists storage groups.

Raghu navaikulam · Posted: Fri Feb 11, 2011 2:17 pm

Hi

You probably mentioned a STOGROUP name which is not available in the catalog table(SYSIBM.SYSSTOGROUP).

Check the SYSIBM.SYSSTOGROUP table for the existance of the STOGROUP you have mentioned in the statement.

The STOGROUP you specified in the create database statement will bypass the STOGROUP name if it is not in the catalog table and will use the default STOGROUP name (SYSDEFLT).

But when you are creating a tablespace in a STOGROUP, DB2 will check whether it is available in the catalog table..

Hope this will help you.

Regards
Raghu

Raghu navaikulam · Posted: Fri Feb 11, 2011 2:18 pm

Hi sreenath.yettapu

Test it and post the result.

Regards
Raghu