Apparently the maximum value of SECQTY for all tablespaces at a site I
am supporting is 131068 which is a pre version 6.2 maximum. Any
insight would be appreciated.
Spufi alter and catalogue queries:
********************************* Top of Data
**********************************
---------+---------+---------+---------+---------+---------+---------+---------+
select dbname, tsname, pqty*4, sqty*4 from sysibm.systablepart where
00010000
dbname='TESTDB' and tsname='TESTTS';
00020001
---------+---------+---------+---------+---------+---------+---------+---------+
DBNAME TSNAME
---------+---------+---------+---------+---------+---------+---------+---------+
TESTDB TESTTS 400000 131068
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---------+---------+
commit;
00030000
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
ALTER TABLESPACE TESTDB.TESTTS SECQTY 200000;
00040000
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
commit;
00041000
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
select dbname, tsname, pqty*4, sqty*4 from sysibm.systablepart where
00050000
dbname='TESTDB' and tsname='TESTTS';
00060001
---------+---------+---------+---------+---------+---------+---------+---------+
DBNAME TSNAME
---------+---------+---------+---------+---------+---------+---------+---------+
TESTDB TESTTS 400000 131068
DSNE610I NUMBER OF ROWS DISPLAYED IS 1
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 100
---------+---------+---------+---------+---------+---------+---------+---------+
---------+---------+---------+---------+---------+---------+---------+---------+
DSNE617I COMMIT PERFORMED, SQLCODE IS 0
DSNE616I STATEMENT EXECUTION WAS SUCCESSFUL, SQLCODE IS 0
---------+---------+---------+---------+---------+---------+---------+---------+
V5 Manual:
If USING STOGROUP is specified, SECQTY has the default specified in the
description of USING STOGROUP. However, if ALTER TABLESPACE is being
used to convert from user-defined data sets to storage groups and
PRIQTY is specified, the default for SECQTY is either 10% of PRIQTY or
3 times the page size of the table space, whichever is
# larger (if this value exceeds 131068, the default is 131068.) If
SECQTY is specified, the secondary space allocation is at least n
kilobytes, where n is the value of integer except in these cases:
If the page size is 4KB and integer is greater than 131068, then n is
131068.
If the page size is 32KB and integer is greater than 131040, then n is
131040.
V 7 IBM Manual:
http://publib.boulder.ibm.com/cgi-bi...0041109152456&
If SECQTY is specified, the secondary space allocation is at least n
kilobytes, where n is the value of integer with the following
exceptions:
If integer is greater than 4194304 kilobytes, n is 4194304. A value of
0 for integer indicates that no data set can be extended.