When you right click in a table from Control Center, then
select "Estimate Size", then Control Center "hangs". A Control
Center trace shows
an invalid query:
) ^ Thread-18
2010-01-04 17:16:06.14 ^
com.ibm.db2.tools.conn.SQLExecute:run()^^^ ^ entry ^ Thread-18
2010-01-04 17:16:06.14 ^
com.ibm.db2.tools.conn.SQLExecute:run()^^^ ^ SQL=SELECT
indschema, indname, definer, tabschema, tabname, tbspaceid,
uniqueRule, colCount, stats_Time, remarks, pctfree, minpctused,
indextype, unique_colcount ,compression ,reverse_scans, ieName,
nLeaf , level2pctfree FROM Syscat.Indexes WHERE indname =
'PK_EMPLOYEE' AND indschema = 'V95INST1' ^ Thread-18
2010-01-04 17:16:06.14 ^
com.ibm.db2.tools.conn.SQLExecute:run()^^^ ^ catch ^ Thread-18
2010-01-04 17:16:06.14 ^
com.ibm.db2.tools.conn.SQLExecute:run()^^^ ^ Exception=[IBM][CLI
Driver][DB2/LINUXX8664] SQL0206N "COMPRESSION" is not valid in
the context where it is used. SQLSTATE=42703
^ Thread-18
2010-01-04 17:16:06.14 ^
com.ibm.db2.tools.conn.SQLExecute:run()^^^ ^ return() ^
Thread-18
2010-01-04 17:16:06.156 ^ db2_udb.Index:obtainDetails()^^^ ^
COM.ibm.db2.jdbc.DB2Exception: [IBM][CLI Driver][DB2/LINUXX8664]
SQL0206N "COMPRESSION" is not valid in the context where it is
used. SQLSTATE=42703
You can get the same error taking the query and running it from
command line.
Using Control Center in 9.5 client going to same server and
choosing 'Estimate Size' does not reproduce this same behavior.
It only occurs from 9.7 client. |
When you right click in a table from Control Center, then
select "Estimate Size", then Control Center "hangs". A Control
Center trace shows
an invalid query:
When you right click in a table from Control Center, then
select "Estimate Size", then Control Center "hangs". A Control
Center trace shows
an invalid query: |
