Longest SQL statement (in bytes)   2097152

라고 메뉴얼에 나오는데요..... 고정되어 있는듯 하내요

User Response:
Either:

• Break the statement up into shorter or less complex SQL statements.
• Increase the size of the statement heap (stmtheap) in the database configuration file.
• Reduce the number of check or referential constraints involved in the statement or reduce the number of indexes on foreign keys.
• Reduce the number of triggers involved in the statement.
• Federated system users: determine which data source is failing the statement (see the problem determination guide for procedures to follow to identify the failing data source) and determine the cause of the rejection. If the rejection is coming from the federated server, increase the size of the statement heap (stmtheap) in the database configuration file.

sqlcode: -101
sqlstate: 54001


To Check the current DB2 Statement Heap Size :

For unix systems:

1) su - <dbadminuser>
2) db2 connect to <dbname>
3) db2 get db config for <dbname>
4) check the SQL statement heap size (STMTHEAP) and update it to 5 times it's current setting using the procedure below.

For windows systems:

1) open a db2 command window
2) db2 connect to <dbname>
3) db2 get db config for <dbname>
4) check the SQL statement heap size (STMTHEAP) and update it to 5 times it's current setting using the procedure below.



To Increase DB2 Statement Heap:

For unix systems:

1. Kill the slapd process
2. su - <dbadminuser>
3. source the <dbname> profile: . sqllib/db2profile
4. Issue the "db2 update db cfg for <dbname> using STMTHEAP <value>" command where dbname is ldapdb2 or whatever db is used for IDS and value is the current statement heap size (STMTHEAP) multiplied by 5.
5. db2stop
6. exit back to root, and restart slapd (which will restart the <dbname> database)



For windows systems:
1. Kill the slapd process
2. open a db2 command window
3. db2 connect to dbname
4. Issue the "db2 update db cfg for <dbname> using STMTHEAP <value>" command where dbname is ldapdb2 or whatever db is used for IDS and value is the current statement heap size (STMTHEAP) multiplied by 5.
5. db2stop
6. exit back to root, and restart slapd (which will restart the <dbname> database)