IBM Support

Error: IGYDS0220-S unable to load DB2 with IBM COBOL for AIX

Troubleshooting


Problem

IGYDS0220-S: The "SQL" compiler option was in effect, but the compiler was unable to load the IBM DB2 SQL coprocessor services module. All "EXEC SQL" statements were discarded.

Cause

IGYDS0220 is a common error. It is seen when DB2 is unable to continue and DB2 needs to inform the compiler of an error. The text of IGYDS0220 differs depending on the DB2 error. This technote applies only to the specific problem just above.

Here are some possible reasons.

  1. Accidentally using the 64-bit version of libdb2.a.
  2. A previous version of COBOL for AIX left pointers to the wrong DB2.
  3. The file /etc/cob2.cfg points to the wrong libdb2.a
  4. DB2 is not started.
  5. An old version of DB2 is used.

Resolving The Problem

Corresponding solutions for the causes above:

  1. The environment variables LIBPATH or LD_LIBRARY_PATH must point to the 32-bit version of libdb2.a at compile time.
  2. Type the slibclean command.
  3. Similar to Cause and Solution number 2 above.
  4. Start DB2.
  5. Type the command db2level to confirm.

[{"Product":{"code":"SS6SGM","label":"COBOL for AIX"},"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Component":"Compiler","Platform":[{"code":"PF002","label":"AIX"}],"Version":"2.0;3.1;4.1","Edition":"","Line of Business":{"code":"LOB17","label":"Mainframe TPS"}}]

Document Information

Modified date:
08 August 2018

UID

swg21233801