PM59520: IMPORTING FROM AS400 USING DB2 CONNECT FAILS WITH RQP-DEF-0177 AND UDA-SQL-0107

APAR status

• Closed as program error.

Error description

• Metadata Wizard to import tables from AS400 V6R1 using DB2
  Connect 9.x native connection will fail after selecting a table
  and click ok with...?RQP-DEF-0177 An error occurred while
  performing operation 'sqlScrollBulkFetch'
  status='-9'.?UDA-SQL-0107 A general exception has occurred
  during the operation "fetch".
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to Cognos BI Server 10.2                             *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

  COG8 BI COG CON

• Fixed component ID

  5724W12CC

Applicable component levels

• RA20 PSN

     UP