OA43642: BUFFER OVERFLOW CAUSED BY LARGE SQL STATEMENTS. SQLCODE -803

Obtain the fix for this APAR.

APAR status

• Closed as program error.

Error description

• Buffer overflow can occur for extremely large SQL statements
  causing SQL errors.  SQL error caused by change in GKB update.
  

Local fix

• N/A
  

Problem summary

• ****************************************************************
  * USERS AFFECTED: All IBM Tivoli Asset Discovery for           *
  *                 z/OS V8.1                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION: Buffer overflow can occur for           *
  *                      extremely large SQL statements          *
  *                      causing SQL errors.                     *
  *                      A SQL error was encountered after a     *
  *                      change was made to the GKB.
  ****************************************************************
  * RECOMMENDATION:                                              *
  ****************************************************************
  For some cases storage buffer overflow can occur for
  extremely large SQL statements construct.
  A SQL error was encountered after a change was made to the GKB.
  

Problem conclusion

• The changes include the following:
  - changed the logic that updates the product_install table
  
  - cleaned up some of the code, improved error checking and
    removed some error codes
  
  - cleaned up and added log messages and added elapsed time
    message
  
  - fixed a buffer overflow problem caused by large SQL
    statements
  
  - fixed the SQL statement that was causing the SQL error
  

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:

  UA71608

Fix information

• Fixed component name

  TIV ASSET DISC

• Fixed component ID

  5698B39TD

Applicable component levels

• R810 PSY UA71608

     UP13/12/07 P F312

Fix is available

• Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.