Open Source Development

Power Open Source Development

Explore the open source tools and capabilities for building and deploying modern applications on IBM Power platforms including AIX, IBM i, and Linux.


#Power


#Power

 View Only

  • 1.  Upgraded from 7.2 TL3 to 7.2 TL4 and issues with perl upgrading from 5.20.1 to 5.281 causing scripts to fail

    Posted Wed April 21, 2021 12:01 PM
    Recently upgraded from 7.2 TL3 to 7.2 TL4 and issues with perl upgrading from 5.20.1 to 5.281 causing perl scripts for DB2 to fail.
    Used CPAN to update modules for DBI and DBI::DBD to be used.
    Receiving the following errors when running the perl script:
    Can't load '/usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/DBI.so' for module DBI: rtld: 0712-001 Symbol __builtin_expect was referenced
    from module /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/DBI.so(), but a runtime definition
    of the symbol was not found. at /usr/opt/perl5/lib/5.28.1/aix-thread-multi/DynaLoader.pm line 193.
    at /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/DBI.pm line 284.
    BEGIN failed--compilation aborted at /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/DBI.pm line 284.
    Compilation failed in require at /dbascripts/scripts/dbaRoutines.pm line 48.
    BEGIN failed--compilation aborted at /dbascripts/scripts/dbaRoutines.pm line 48.
    Compilation failed in require at /dbascripts/scripts/menuDprop.pl line 27.
    BEGIN failed--compilation aborted at /dbascripts/scripts/menuDprop.pl line 27.

    Also noticed that DBD::DB2 was now missing so tried to install that using CPAN but also getting issues tied to that:
    The content of '/root/.cpan/build/DBD-DB2-1.85-4/META.yml' is not a HASH reference. Cannot use it.
    The content of '/root/.cpan/build/DBD-DB2-1.85-4/META.yml' is not a HASH reference. Cannot use it.
    Configuring I/IB/IBMTORDB2/DBD-DB2-1.85.tar.gz with Makefile.PL
    Can't load '/usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/DBI.so' for module DBI: rtld: 0712-001 Symbol __builtin_expect was referenced
    from module /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/auto/DBI/DBI.so(), but a runtime definition
    of the symbol was not found. at /usr/opt/perl5/lib/5.28.1/aix-thread-multi/DynaLoader.pm line 193.
    at /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/DBI.pm line 284.
    BEGIN failed--compilation aborted at /usr/opt/perl5/lib/site_perl/5.28.1/aix-thread-multi/DBI.pm line 284.
    Compilation failed in require at Makefile.PL line 13.
    BEGIN failed--compilation aborted at Makefile.PL line 13.
    Warning: No success on command[/usr/opt/perl5/bin/perl Makefile.PL]
    IBMTORDB2/DBD-DB2-1.85.tar.gz
    /usr/opt/perl5/bin/perl Makefile.PL -- NOT OK
    Failed during this command:
    IBMTORDB2/DBD-DB2-1.85.tar.gz : writemakefile NO '/usr/opt/perl5/bin/perl Makefile.PL' returned status 2048

    Any advice or suggestions on what to try next to resolve??  These perl scripts were written back in 2006 and were working on other versions of perl.

    Thanks,
    Rob




    ------------------------------
    Robert Franklin
    ------------------------------

    #AIXOpenSource


  • 2.  RE: Upgraded from 7.2 TL3 to 7.2 TL4 and issues with perl upgrading from 5.20.1 to 5.281 causing scripts to fail

    Posted Wed April 21, 2021 06:20 PM

    Since Robert has an AIX case, I wanted to share some of the reference links for DBD-DB2 on the thread.

    CAVEATS: https://metacpan.org/source/ROCKETDB/DBD-DB2-1.86/CAVEATS 
    README:      https://metacpan.org/source/ROCKETDB/DBD-DB2-1.86/README


    He checked db fileset:
    db2_08_0r.adt.rte        8.1.1.160    C     F    Base Application Development

    I think that is the "DB2 Application Development Client, but did sent note to db2 team to confirm.  We have also sent a case to the Rocket DB2 Tools team for DBD-DB2 support.

     



    ------------------------------
    Jan Harris
    ------------------------------

    Original Message


  • 3.  RE: Upgraded from 7.2 TL3 to 7.2 TL4 and issues with perl upgrading from 5.20.1 to 5.281 causing scripts to fail

    Posted Thu April 22, 2021 09:53 AM
    Hi Robert - We did not want to leave this thread "unanswered".
    Since we  have a case with DB2 support, and I am watching it, I have advised Sangamesh that I will engage him directly if Rocket needs any AIX Open Source assistance.

    ------------------------------
    Jan Harris
    ------------------------------

    Original Message


  • 4.  RE: Upgraded from 7.2 TL3 to 7.2 TL4 and issues with perl upgrading from 5.20.1 to 5.281 causing scripts to fail

    Posted Thu April 22, 2021 05:23 PM
    There is a bug in 5.28.1.2, you need to patch to 5.28.1.3.  Have you tried both the 32-bit and 64-bit versions of perl? 64-bit usually fixes most of my issues

    mv /usr/opt/perl5/bin/perl /usr/opt/perl5/bin/perl_32bit
    mv /usr/opt/perl5/bin/perl5.28.1 /usr/opt/perl5/bin/perl5.28.1_32bit
    ln -sf /usr/opt/perl5/bin/perl_32bit /usr/bin/perl32
    ln -sf /usr/opt/perl5/bin/perl_64bit /usr/bin/perl
    ln -sf /usr/opt/perl5/bin/perl_64bit /usr/opt/perl5/bin/perl
    ln -sf /usr/opt/perl5/bin/perl5.28.1_64bit /usr/opt/perl5/bin/perl5.28.1


    ------------------------------
    James Franznick
    ------------------------------

    Original Message


Related Content