error: command 'xlc_r' failed: No such file or directory

[jmuellerDO]

• Operating System Name: AIX

• db2level output from clidriver if in use:

• Target Db2 Server Version: DB2 v12.1.2.0

• Python Version:Python 3.9.19

• ibm_db version:3.2.6

• For non-Windows, output of below commands:
  uname
  uname -m

• Value of below environment variables if set:
  IBM_DB_HOME:
  PATH:
  LIB/LD_LIBRARY_PATH/DYLD_LIBRARY_PATH:

• Test script to reproduce the problem.

• For installation related issue, complete output of pip install ibm_db command.

Steps to Reproduce:

pip3 install ibm_db
Defaulting to user installation because normal site-packages is not writeable
Collecting ibm_db
Using cached ibm_db-3.2.6.tar.gz (262 kB)
Installing build dependencies ... done
Getting requirements to build wheel ... done
Preparing metadata (pyproject.toml) ... done
Building wheels for collected packages: ibm_db
Building wheel for ibm_db (pyproject.toml) ... error
error: subprocess-exited-with-error

Building wheel for ibm_db (pyproject.toml) did not run successfully.
exit code: 1

[228 lines of output]
Detected 64-bit Python
Pre-installed Db2 client detected in the system as /opt/IBM/db2/12.1.2
Please make sure you have set IBM_DB_HOME = /opt/IBM/db2/12.1.2 to avoid FileNotFoundError.
Found DB2 ODBC Driver from PATH, so skipping the clidriver download.
Pre-requisite check [gcc] : Passed
Pre-requisite check [Python.h] : Passed
/tmp/pip-build-env-j3o2p8mp/overlay/lib/python3.9/site-packages/setuptools/dist.py:759: SetuptoolsDeprecationWarning: License classifiers are deprecated.
!!

      ********************************************************************************
      Please consider removing the following classifiers in favor of a SPDX license expression:

      License :: OSI Approved :: Apache Software License

      See https://packaging.python.org/en/latest/guides/writing-pyproject-toml/#license for details.
      ********************************************************************************

!!
self._finalize_license_expression()
running bdist_wheel
running build
running build_py
creating build/lib.aix-7302-2445-64-cpython-39
copying ibm_db_dbi.py -> build/lib.aix-7302-2445-64-cpython-39
copying testfunctions.py -> build/lib.aix-7302-2445-64-cpython-39
copying ibmdb_tests.py -> build/lib.aix-7302-2445-64-cpython-39
copying ibm_db_ctx.py -> build/lib.aix-7302-2445-64-cpython-39
creating build/lib.aix-7302-2445-64-cpython-39/certs
copying certs/init.py -> build/lib.aix-7302-2445-64-cpython-39/certs
creating build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/init.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_000_PrepareDb.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_001_ConnDb.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_002_ConnDbUncatalogedConn.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_003_NumAffectedRows.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_004_ConnWrongUserPwd.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_005_ConnBadUserBadPwd.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_006_ConnPassingOpts.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_007_pConnPassingOpts.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_008_ColumnInfo.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_010_UpdateRowCount.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_011_DeleteRowCount.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_012_KeysetDrivenCursorSelect01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_013_KeysetDrivenCursorSelect02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_014_KeysetDrivenCursorNegativeRow.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_015_InsertDeleteRowCount_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_016_InsertDeleteRowCount_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_017_selectRowcountPrefetchSTMTOpt.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_018_selectRowcountPrefetchSetOpt.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_019_selectRowcountPrefetchPrepOpt.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_020_RollbackDelete.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_021_CommitDelete.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_022_RollbackInsert.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_023_ColumnPrivileges.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_024_ForeignKeys.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_025_PrimaryKeys.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_030_Result.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_031_ResultIndexPosition.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_032_ResultIndexName.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_033_ResultOutSequenceColumn.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_034_FetchAssoc.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_035_FetchRow_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_036_FetchRow_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_037_FetchRowIndexPos.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_038_FetchRowIndexPosNested_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_039_FetchRowIndexPosNested_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_03a_ResultNonExistCol.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_040_FetchTuple.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_041_FetchTupleMany_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_042_FetchTupleMany_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_043_FetchTupleMany_03.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_044_FetchTupleMany_04.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_045_FetchTupleBinaryData_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_046_FetchTupleMany_05.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_047_FetchTupleMany_06.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_048_FetchTupleBinaryData_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_049_InsertNoneParam.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_050_AutocommitStatus.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_051_SetAutocommit_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_052_SetAutocommit_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_053_AttrThruConn.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_054_CursorType.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_060_Tables_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_061_Tables_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_062_Tables_03.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_063_Tables_04.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_064_Tables_05.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_065_FilterTableName.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_066_TableObjects.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_070_Close.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_071_CloseSuccess.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_080_ConnWrongDbAlias.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_081_ConnWrongUser.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_082_ConnWrongPwd.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_090_ConnmsgWrongDbAlias.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_091_ConnmsgWrongUser.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_092_ConnmsgWrongPwd.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_100_SelectDeleteInsertFieldCount.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_101_InsertDeleteFieldCount.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_102_NumFieldsSelect_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_103_NumFieldsSelect_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_110_FieldNum.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_111_FieldNumAddCol.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_112_FieldNumDiffCaseColNames.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_113_DateTest.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_114_NumericTest_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_115_NumericTest_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_116_ConnActive.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_120_FieldName.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_121_FieldNameAddCol.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_122_FieldNameDiffCaseColNames.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_123_FieldNamePos_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_124_FieldNamePos_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_125_FieldNamePos_03.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_130_PrepExecuteSelectStmt.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_131_PrepareExecuteSelectStatementParams.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_132_ExecuteStatementArrayMultipleParams.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_133_ExecuteLongInputParams.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_140_BindParamSelectStmt.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_141_BindParamSelectStmtMultipleParams_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_142_BindParamSelectStmtMultipleParams_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_143_BindParamInsertStmtNoneParam.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_144_BindParamInsertStmtPARAM_FILE.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_145_BindRetrieveNoneEmptyString.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_146_CallSPINAndOUTParams.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_146a_CallSPINAndOUT_Blob_Param.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_147_PrepareWithWrongType.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_148_CallSPDiffBindPattern_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_150_FetchAssocSelect_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_151_FetchAssocSelect_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_152_FetchAssocSelect_03.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_153_FetchAssocSelect_04.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_154_AllFetches.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_155_FetchAssocSelect_05.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_156_FetchAssocNestedSelects_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_157_FetchAssocScrollableCursor_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_157a_FetchAssocWithoutScrollableCursorErr.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_157b_FetchAssocScrollableCursor_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_158_FetchAssocNestedSelects_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_159_FetchAssocSeveralRows_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_159a_FetchAssocSeveralRows_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_160_FetchBoth.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_161_FetchBothNestedSelects_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_162_FetchBothNestedSelects_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_180_StmtErrMsg.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_190_ColumnsTable_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_191_ColumnsTable_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_195_InsertRetrieveXMLData_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_196_InsertRetrieveXMLData_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_197_StatisticsIndexes.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_200_MultipleRsltsetsUniformColDefs.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_201_MultipleRsltsetsDiffColDefs.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_210_FieldDisplaySize_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_211_FieldDisplaySize_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_212_FieldDisplaySize_03.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_213_FieldDisplaySize_04.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_220_PersistentConn.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_221_100PersistentConns.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_230_FieldTypePos.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_231_FieldTypeName.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_232_FieldTypePosName.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_240_FieldWidthPosName_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_241_FieldWidthPosName_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_250_FreeResult_01.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_251_FreeResult_02.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_260_FetchTupleMany_07.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_261_FetchObjectAccess.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_264_InsertRetrieveBIGINTTypeColumn.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_265_NoAffectedRows.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_300_ServerInfo.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_310_ClientInfo.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_311_InsertSelectDeleteNumLiterals.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_312_FetchOne.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_313_FetchMany.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_314_FetchAll.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_315_FetchAll_DBI.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_52949_TestSPIntVarcharXml.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_6528_ScopingProblemBindParam.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_6561_InsertNULLValues.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_6755_ExtraNULLChar_ResultCLOBCol.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_6792_FieldTypeRetStrDatetimeTimestamp.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_InsertRetrieveDateTimeTypeColumn.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_SPInOutBlob.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_SPInOutZero.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_alltypes.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_alltypesarray.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_bool_callproc.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_booleanInsertSelect.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_checkBooleanType.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_conn_get_sqlcode.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_context_ConnActive.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_context_ConnDb.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_context_ConnDbUncatalogedConn.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_createDropDB.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_createdbNX.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_currentschema.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_cursortype.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_decfloat.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_decimal.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_err_executemany.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_execute_many.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_recreateDB.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_setgetOption.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_sp_return.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_stmt_get_sqlcode.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_trusted_context_connect.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_trusted_context_pconnect.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_unicodeTable.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
copying ibm_db_tests/test_warn.py -> build/lib.aix-7302-2445-64-cpython-39/ibm_db_tests
running egg_info
writing ibm_db.egg-info/PKG-INFO
writing dependency_links to ibm_db.egg-info/dependency_links.txt
writing top-level names to ibm_db.egg-info/top_level.txt
reading manifest file 'ibm_db.egg-info/SOURCES.txt'
reading manifest template 'MANIFEST.in'
warning: no files found matching '.png' under directory 'ibm_db_tests'
warning: no files found matching '.jpg' under directory 'ibm_db_tests'
warning: no files found matching '' under directory 'clidriver'
warning: no files found matching '' under directory 'ibm_db_dlls'
warning: no previously-included files found matching 'config.py'
adding license file 'LICENSE'
writing manifest file 'ibm_db.egg-info/SOURCES.txt'
copying certs/ibm_certs.pem -> build/lib.aix-7302-2445-64-cpython-39/certs
running build_ext
building 'ibm_db' extension
creating build/temp.aix-7302-2445-64-cpython-39
xlc_r -q64 -qPIC -DNDEBUG -O2 -qmaxmem=-1 -I/usr/opt/python3/include -I/usr/include -D_ALL_SOURCE -D_LINUX_SOURCE_COMPAT -qbitfields=signed -qalloca -O2 -qmaxmem=-1 -I/usr/opt/python3/include -I/usr/include -D_ALL_SOURCE -D_LINUX_SOURCE_COMPAT -qbitfields=signed -qalloca -O2 -qmaxmem=-1 -I/db2/db2bet/sqllib/include -I/usr/opt/python3/include/python3.9 -c ibm_db.c -o build/temp.aix-7302-2445-64-cpython-39/ibm_db.o
error: command 'xlc_r' failed: No such file or directory
[end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.
ERROR: Failed building wheel for ibm_db
Failed to build ibm_db
ERROR: Failed to build installable wheels for some pyproject.toml based projects (ibm_db)

[jmuellerDO]

With the new AIX level 7300-02-03-2446 bulding the wheel pip will only use xlc_r. This was the first call of the command when xlc was not installed:

`pip3 install ibm_db
Collecting ibm_db
Downloading ibm_db-3.2.6.tar.gz (262 kB)
Installing build dependencies ... done
Getting requirements to build wheel ... error
error: subprocess-exited-with-error

Getting requirements to build wheel did not run successfully.
exit code: 1

[8 lines of output]
Detected 64-bit Python
Detected platform = aix, uname = 00CA2AB14B00
Downloading https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/v11.5.9/aix64_odbc_cli.tar.gz
Downloading DSDriver from url = https://public.dhe.ibm.com/ibmdl/export/pub/software/data/db2/drivers/odbc_cli/v11.5.9/aix64_odbc_cli.tar.gz
Pre-requisite check [which gcc] : Failed

No Gcc installation detected.
Please install gcc and continue with the installation of the ibm_db.
[end of output]

note: This error originates from a subprocess, and is likely not a problem with pip.`

[Earammak]

@jmuellerDO , Can you please check is xLC complier installed in the system?

[jmuellerDO]

Hello Earmmak,

Thanks for supporting me.
No, we do not have a xlc compiler. For this we have to buy a xlc compiler for each AIX system. Before the new AIX Version 7300-02-03-2446 we do not need a xlc compiler. I never had done this before.

[jmuellerDO]

Could it be that pip has previously downloaded a finished build instead of recompiling it now?

[Earammak]

@jmuellerDO , "pip3 install ibm_db" command always installs from source code, which means that it takes the compilation process too. So, it will not use like previously downloaded one.

[Earammak]

@jmuellerDO , Please refer to https://www.ibm.com/support/pages/aix-os-levels-supported-xl-compilers AIX os levels supported by xlc compiler.
If you install ptf version xlc compiler and set set PATH of the xlc compiler , you will be able to install ibm_db successfully.
You need to install this V16.1.0.10 PTF patch ( https://www.ibm.com/support/pages/apar/IJ36514 ).

Thanks

[Earammak]

@jmuellerDO , Any update on this issue?

[jmuellerDO]

@Earammak so it seems that we have to buy a xlc compiler license, which we never used before.
That's happen after updating to AIX 7.3

We will test it with a xlc compiler, how it works...

[Earammak]

@jmuellerDO, I hope you have tested with aix7.3 xlc compiler. Please do share the update here.

Thanks

[jmuellerDO]

@Earammak , not yet. There are problems. As I wrote before we have to buy a xlc compiler only for this python module build.