I am trying to run a DB2/CLI app that was built in the AIX
4.3.3/DB27.2 env on AIX5.2/DB28.1. The app doesn't run and complains
that a set of symbols are not exported from libdb2.a. Actually these
symbols are defined (as seen in dump -Tv output) in shr.o module in
libdb2.a. I extracted shr.o from libdb2.a, renamed to db2.o and put
under sqllib/lib, and that also doesn't fix the problem. However, dump
of libdb2.a doesn't list these symbols. Why is that and is there a
fix?

IBM support suggeted that configuration for ODBC has to be done. But
that was not needed in that past as the app uses only CLI APIs.

Please help with your suggestions.

Thanks
Thomas.

What are the symbols?

Thomas Theakanath wrote:

Sean McKeough <mckeough (AT) nospam (DOT) ca.ibm.com> wrote

Symbols are listed in the error message (given below) that I am
getting when the app is run. libxyz.so is dynamically linked to
libdb2.a. prg1 is a 32-bit app and in the current runtime env, the
lib/libdb2.a points to a version of the same file in sqllib/lib64
directory. Could that be a problem?

exec(): 0509-036 Cannot load program prg1 because of the following
errors:
0509-130 Symbol resolution failed for /mass1/server/libs/libxyz.so
because:
0509-136 Symbol sqlt_last (number 133) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlt_compname (number 148) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlt_names (number 149) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol __priority0x80000400 (number 165) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqle_dbm_dari__FP17sqlcc_init_structcsUs (number
236) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleget_agentid__Fv (number 298) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleStartAppSavePoint (number 304) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleEndAppSavePoint (number 305) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleRollbackAppSavePoint (number 306) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASStartServ (number 315) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASStartServ2 (number 316) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASStopServ (number 317) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASStopServ2 (number 318) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASQueryServ (number 319) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASListUsers (number 320) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASListGrps (number 321) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASUserGrps (number 322) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASListProcs (number 323) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASListFS (number 324) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetFSAttrib (number 325) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASFindFirst (number 326) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASFindNext (number 327) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASFindClose (number 328) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetFileAttr (number 329) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASReadFile (number 330) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASWriteFile (number 331) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASDeleteFile (number 332) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASCreateDir (number 333) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASDeleteDir (number 334) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetSysInfo (number 335) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASAddLicense (number 336) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASRequestAccess (number 337) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetInstallPath (number 338) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetMiscInfo (number 339) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetNumberOfUsers (number 340) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASRemoveLicense (number 341) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASAddRegisteredUser (number 342) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASRemoveRegisteredUser (number 343) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetProduct (number 344) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetCurrentUsers (number 345) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetRegisteredUsers (number 346) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetBriefStats (number 347) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetGraphStats (number 348) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASUpdateLicense (number 349) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASAddLicenseManual (number 350) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASGetRegDetails (number 351) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleRemoteRequestAccess (number 352) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASListDb2nodesCfg (number 353) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASdinsvc (number 354) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASPRegVSFirst (number 355) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASPRegVSNext (number 356) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASPRegVSClose (number 357) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASPRegVQuery (number 358) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASPRegVDelete (number 359) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASPRegVSet (number 360) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleDASPRegVReset (number 361) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleScheduleEvent (number 363) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleCancelEvent (number 364) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleExecuteEvent (number 365) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleChangeEventState (number 366) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleReScheduleEvent (number 367) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleOpenScheduleEventScan (number 368) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleCloseScheduleEventScan (number 369) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleFetchScheduleEventInfo (number 370) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleOpenInfoBaseScan (number 371) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleCloseInfoBaseScan (number 372) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleFetchInfoBaseInfo (number 373) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleExecuteInfoBaseRequest (number 374) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqleAdminScheduler (number 375) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlm_extract_switches__FPUcPUlUsP16sqlm_header_inf o
(number 458) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlm_extract_switches__FP20sqlm_recording_groupUsP 16sqlm_header_info
(number 459) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlogopt__FiPPcPcP13sqlo_goptargs (number 463) is
not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqloGetGlobApp__Fv (number 464) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlo_md_v (number 497) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol md_ValidateBlk (number 498) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol md_CallProc (number 506) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlofpol__FP8SMemPool (number 508) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqloreallocblk (number 511) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlogmshr2 (number 513) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlofshr2__FP12sqlo_mem_set (number 515) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlocshr2__FP12sqlo_mem_setPcUi (number 516) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlodshr__FP12sqlo_mem_set (number 517) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqloGetSetInfo__FP12sqlo_mem_setP17sqlo_mem_set_in fo
(number 519) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqloMemSetPtr__FP12sqlo_mem_setiT2PPv (number 520)
is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqloh2st__FP12sqlo_mem_setPcPUl (number 521) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlost2h__FP12sqlo_mem_setPCc (number 522) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqloIsInstanceActive__FPci (number 523) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol squsGetColumnAndPartitionAndRIInfo__FP7sqlcharUcUi P15sqlu_media_listP11sqluload_inT1PUcP7sqldcolUsN2 7PiT12_PP8partcolsN312_P15filetmodOptionsN37PPsT12 _P5sqlca
(number 526) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol CLI_scnTranslateJSQLString (number 610) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol CLI_scnGetJSQLProcName (number 611) is not exported
from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol CLI_scnTranslateJSQLSelectStmt (number 612) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol CLI_scnParseCompoundJSQLString (number 613) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol CLI_scnParseJSQLCallStmt (number 614) is not
exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlccinit__FP17sqlcc_init_structPP15sqlcc_comhandl eP10sqlcc_cond
(number 811) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlccfreebuffer__FP15sqlcc_comhandlePcP10sqlcc_con d
(number 824) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlccregserv__FUsPvP9sqlf_kcfdP10sqlcc_cond (number
828) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlccderegserv__FUsPvP9sqlf_kcfdP10sqlcc_cond
(number 829) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-136 Symbol sqlcspes (number 830) is not exported from
dependent module /mass1/db2inst1/sqllib/lib/libdb2.a(shr.o).
0509-021 Additional errors occurred but are not reported.
0509-192 Examine .loader section symbols with the
'dump -Tv' command.

Thomas Theakanath wrote:

Yeah - 32-bit apps need to have LIBPATH including sqllib/lib32 to be
able to load the 32-bit libraries.

I don't see lib32 directory under sqllib of the instance that I am
using. Nor under the server installation. Is there an option to
install 32-bit libs while installing Db2 server/client?

Thanks for the info.
Thomas.