PM39779: Setting up Full Text Search on a db2 9.7 database gives DataDirect error 'No more available statements'

Rational ClearQuest Fix Pack (8.0.0.1) for version 8.0
Rational ClearQuest Fix Pack (7.1.2.5) for version 7.1.2
Rational ClearQuest Fix Pack 14 (7.1.2.14) for 7.1.2
Rational ClearQuest Fix Pack 11 (8.0.0.11) for 8.0
Rational ClearQuest Fix Pack 12 (8.0.0.12) for 8.0
Rational ClearQuest Fix Pack 15 (7.1.2.15) for 7.1.2
Rational ClearQuest Fix Pack 13 (8.0.0.13) for 8.0
Rational ClearQuest Fix Pack 16 (7.1.2.16) for 7.1.2
Rational ClearQuest Fix Pack 17 (7.1.2.17) for 7.1.2
Rational ClearQuest Fix Pack 14 (8.0.0.14) for 8.0
Rational ClearQuest Fix Pack 18 (7.1.2.18) for 7.1.2
Rational ClearQuest Fix Pack 15 (8.0.0.15) for 8.0
Rational ClearQuest Fix Pack 19 (7.1.2.19) for 7.1.2
Rational ClearQuest Fix Pack 16 (8.0.0.16) for 8.0
Rational ClearQuest Fix Pack 17 (8.0.0.17) for 8.0
Rational ClearQuest Fix Pack 18 (8.0.0.18) for 8.0
Rational ClearQuest Fix Pack 19 (8.0.0.19) for 8.0
Rational ClearQuest Fix Pack 20 (8.0.0.20) for 8.0
Rational ClearQuest Fix Pack 21 (8.0.0.21) for 8.0

APAR status

• Closed as program error.

Error description

• Setting up Full Text Search  on a db2 9.7  FP3 database  using
  default DataDirect drivers  gives error  'No more available
  statements' at the initialization state.
  
  C:\Program Files\IBM\RationalSDLC\ClearQuest?cqperl cqtsadmin.pl
  --username admin n --password '' --dbset ibmdb2 --userdb vidya
  --ftshome C:\CQ.Search --init_cq_fts
  
  Exception in thread 'main'
  com.rational.clearquest.cqjni.CQException: Caught a CQException
  at the JNI Boundary:
  \bugbert.src\cqobjectmodel\cqresultset.cpp: line 179-CRMDB0001E
  SQLExecDirect: R
  ETCODE=-1, State=S1000, Native Error=8292
  [IBM Rational DataDirect][ODBC DB2 Wire Protocol driver]No more
  available statements. Please recreate your package with a larger
  dynamicSections value.
  SQL statement='select count(*) from customer_4 where dbid ?? 0'
          at
  com.ibm.rational.clearquest.cqtscrawler.common.ConfigGenerator.p
  rintProcessEntityFields(ConfigGenerator.java:524)
          at
  com.ibm.rational.clearquest.cqtscrawler.common.ConfigGenerator.g
  enerateEntityFile(ConfigGenerator.java:151)
          at
  com.ibm.rational.clearquest.cqtscrawler.common.ConfigGenerator.m
  ain(ConfigGenerator.java:120)
  
  
  The same command works fine using using DB2 drivers.
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  Setting up ClearQuest Full Text Search against a DB2 9.7 FP3
  Database results in the following error message:
  
  [IBM Rational DataDirect][ODBC DB2 Wire Protocol driver]No
  more available statements. Please recreate your package with
  a larger dynamicSections value.
  

Problem conclusion

• A fix is available in ClearQuest 7.1.1.8, 7.1.2.5, and
  8.0.0.1
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  CLEARQUEST WIN

• Fixed component ID

  5724G3600

Applicable component levels

• R711 PSN

     UP