While running following command
CREATE INDEX ABC.CDE_X1 ON ABC.CDE (C1 ASC, C2 ASC, C3 ASC, C4 ASC )
allow reverse scans collect detailed statistics
DB21034E The command was processed as an SQL statement because it was
not a
valid Command Line Processor command. During SQL processing it
returned:
SQL10003C There are not enough system resources to process the
request. The
request cannot be processed. SQLSTATE=57011
table has 28 million rows. db2mtrk output is following:
##################### db2mtrk -i -d -m
Tracking Memory on: 2007/05/31 at 15:48:27
Memory for instance
fcmbp monh other
16.8M 368.0K 22.2M
Memory for database: ABCD
utilh pckcacheh catcacheh bph bph bph bph
195.3M 16.0G 16.0G 16.0G 16.0G 16.0G 16.0G
bph bph bph bph bph bph bph
16.0G 16.0G 16.0G 16.0G 16.0G 16.0G 16.0G
bph bph shsorth lockh dbh other appctlh
16.0G 16.0G 390.6M 1.0G 232.1M 12.0M 1.4M
appctlh appctlh appctlh appctlh appctlh appctlh appctlh
1.4M 1.4M 1.4M 1.4M 1.4M 1.4M 1.4M
appctlh appctlh appctlh appctlh appctlh appctlh appctlh
1.4M 1.4M 1.4M 1.4M 1.4M 1.4M 1.4M
appctlh appctlh appctlh appctlh appctlh appctlh appctlh
1.4M 1.4M 1.4M 1.4M 1.4M 1.4M 1.4M
appctlh appctlh appctlh appctlh agsh
1.4M 1.4M 1.4M 1.4M 273.6M
###################### db2mtrk -i -d -w
Tracking Memory on: 2007/05/31 at 15:58:56
Memory for instance
fcmbp monh other
16.7M 224.0K 4.6M
Memory for database: ABCD
utilh pckcacheh catcacheh bph bph bph bph
240.0K 35.2M 4.3M 157.9M 305.3M 157.9M 203.5M
bph bph bph bph bph bph bph
30.6M 407.1M 305.3M 30.6M 814.1M 656.0K 400.0K
bph bph shsorth lockh dbh other appctlh
272.0K 208.0K 171.0M 1.0G 14.6M 16.0K 32.0K
appctlh appctlh appctlh appctlh appctlh appctlh appctlh
48.0K 16.0K 64.0K 32.0K 16.0K 64.0K 64.0K
appctlh appctlh appctlh appctlh appctlh appctlh appctlh
112.0K 144.0K 96.0K 80.0K 64.0K 112.0K 128.0K
appctlh appctlh appctlh appctlh appctlh appctlh appctlh
64.0K 80.0K 176.0K 96.0K 80.0K 96.0K 112.0K
appctlh appctlh appctlh appctlh agsh
96.0K 16.0K 80.0K 624.0K 136.7M
what will solve this problem ?
regards,