By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,287 Members | 1,287 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,287 IT Pros & Developers. It's quick & easy.

db2 - indexes

P: n/a
J have tablespace named TSPACE, with table DATA with about 3mln rows.
I want to create index named O123TA, but execution ends with error:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY
AN UNAVAILABLE RESOURCE. REASON 00D70014, TYPE OF RESOURCE 00000220,
AND RESOURCE NAME
DBIV71.DSNDBC.USPLPPL.O123TA.I0001.A001

I think, there is problem with free space, so i increased by tablespace
quadruply, but it has changed nothing.

Where is problem?

Michal
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Hello,

First, DB2 for z/OS does not store table and index data within the same
dataset (file)! It allocates at least one new file for each index you
create.
Second, and the VSAM "file system" used by DB2 for z/OS does not extend
files infinitely until all available disk space is used. Therefore, you must
specify a "primary" (initial) and "secondary" (increment) size for each
table-and indexspace by specifying the PRIQTY <kB> and SECQTY <kB> keywords
within your CREATE INDEX - Statement. If you omit this keywords, DB2 uses a
very small default of 48kB for both, which is obviously not applicable for
your table .

Cheers - Walter.

"Michal Krawczyk" <ca*******@poczta.onet.pl> schrieb im Newsbeitrag
news:cj**********@flis.man.torun.pl...
J have tablespace named TSPACE, with table DATA with about 3mln rows.
I want to create index named O123TA, but execution ends with error:

DSNT408I SQLCODE = -904, ERROR: UNSUCCESSFUL EXECUTION CAUSED BY
AN UNAVAILABLE RESOURCE. REASON 00D70014, TYPE OF RESOURCE 00000220, AND RESOURCE NAME
DBIV71.DSNDBC.USPLPPL.O123TA.I0001.A001

I think, there is problem with free space, so i increased by tablespace
quadruply, but it has changed nothing.

Where is problem?

Michal

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.