DBI 1.609-ithread default trace level set to 0x0/9 (pid 1953922) at DBI.pm line 273 via db2Connect.pl line 1 -> DBI->connect(dbi:DB2:pdm01p, qooslct, ****, HASH(0x2000a078)) -> DBI->install_driver(DB2) for aix perl=5.008008 pid=1953922 ruid=4016 euid=4016 install_driver: DBD::DB2 version 1.79 loaded from /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBD/DB2.pm New 'DBI::dr' (for DBD::DB2::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x201d3630)=>DBI::dr=HASH(0x201d3588), DBD::DB2::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::DB2::dr, 96, 0) thr#200093a8 dbih_setup_attrib(DBI::dr=HASH(0x201d3588), Err, Null!) SCALAR(0x20325dcc) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x201d3588), State, Null!) SCALAR(0x200c5fec) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x201d3588), Errstr, Null!) SCALAR(0x200c6004) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x201d3588), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x201d3588), FetchHashKeyName, Null!) 'NAME' (already defined) <- install_driver= DBI::dr=HASH(0x201d3630) >> connect DISPATCH (DBI::dr=HASH(0x201d3630) rc2/3 @5 g0 ima8001 pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 653 !! warn: 0 CLEARED by call to connect method -> connect for DBD::DB2::dr (DBI::dr=HASH(0x201d3630)~0x201d3588 'pdm01p' 'qooslct' **** HASH(0x200d278c)) thr#200093a8 New 'DBI::db' (for DBD::DB2::db, parent=DBI::dr=HASH(0x201d3588), id=undef) dbih_setup_handle(DBI::db=HASH(0x201b7ed4)=>DBI::db=HASH(0x201b7e50), DBD::DB2::db, 2011f94c, Null!) dbih_make_com(DBI::dr=HASH(0x201d3588), 2006b778, DBD::DB2::db, 104, 0) thr#200093a8 dbih_setup_attrib(DBI::db=HASH(0x201b7e50), Err, DBI::dr=HASH(0x201d3588)) SCALAR(0x2011fad8) (already defined) dbih_setup_attrib(DBI::db=HASH(0x201b7e50), State, DBI::dr=HASH(0x201d3588)) SCALAR(0x2011fb38) (already defined) dbih_setup_attrib(DBI::db=HASH(0x201b7e50), Errstr, DBI::dr=HASH(0x201d3588)) SCALAR(0x2011fb08) (already defined) dbih_setup_attrib(DBI::db=HASH(0x201b7e50), TraceLevel, DBI::dr=HASH(0x201d3588)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x201b7e50), FetchHashKeyName, DBI::dr=HASH(0x201d3588)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x201b7e50), HandleSetErr, DBI::dr=HASH(0x201d3588)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x201b7e50), HandleError, DBI::dr=HASH(0x201d3588)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x201b7e50), ReadOnly, DBI::dr=HASH(0x201d3588)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x201b7e50), Profile, DBI::dr=HASH(0x201d3588)) undef (not defined) connect 'pdm01p', 'qooslct', '****' <- connect= DBI::db=HASH(0x201b7ed4) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 653 >> STORE DISPATCH (DBI::db=HASH(0x201b7e50) rc2/1 @3 g0 ima41c pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 705 -> STORE for DBD::DB2::db (DBI::db=HASH(0x201b7e50)~INNER 'RaiseError' 1) thr#200093a8 STORE DBI::db=HASH(0x201b7e50) 'RaiseError' => 1 <- STORE= 1 at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 705 >> STORE DISPATCH (DBI::db=HASH(0x201b7e50) rc2/1 @3 g0 ima41c pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 705 -> STORE for DBD::DB2::db (DBI::db=HASH(0x201b7e50)~INNER 'PrintError' 1) thr#200093a8 STORE DBI::db=HASH(0x201b7e50) 'PrintError' => 1 <- STORE= 1 at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 705 >> STORE DISPATCH (DBI::db=HASH(0x201b7e50) rc2/1 @3 g0 ima41c pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 705 -> STORE for DBD::DB2::db (DBI::db=HASH(0x201b7e50)~INNER 'AutoCommit' 1) thr#200093a8 <- STORE= 1 at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 705 >> STORE DISPATCH (DBI::db=HASH(0x201b7e50) rc2/1 @3 g0 ima41c pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 708 via at db2Connect.pl line 4 -> STORE for DBD::DB2::db (DBI::db=HASH(0x201b7e50)~INNER 'Username' 'qooslct') thr#200093a8 STORE DBI::db=HASH(0x201b7e50) 'Username' => 'qooslct' <- STORE= 1 at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 708 via at db2Connect.pl line 4 >> FETCH DISPATCH (DBI::db=HASH(0x201b7e50) rc2/1 @2 g0 ima404 pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 708 <> FETCH= 'qooslct' ('Username' from cache) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 708 >> connected DISPATCH (DBI::db=HASH(0x201b7ed4) rc1/1 @5 g0 ima5 pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 714 -> connected in DBD::_::db for DBD::DB2::db (DBI::db=HASH(0x201b7ed4)~0x201b7e50 'dbi:DB2:pdm01p' 'qooslct' '****' HASH(0x2000a078)) thr#200093a8 <- connected= undef at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 714 <- connect= DBI::db=HASH(0x201b7ed4) >> STORE DISPATCH (DBI::db=HASH(0x201b7e50) rc2/1 @3 g0 ima41c pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 723 via at db2Connect.pl line 4 -> STORE for DBD::DB2::db (DBI::db=HASH(0x201b7e50)~INNER 'dbi_connect_closure' CODE(0x201d3750)) thr#200093a8 STORE DBI::db=HASH(0x201b7e50) 'dbi_connect_closure' => CODE(0x201d3750) <- STORE= 1 at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 723 via at db2Connect.pl line 4 >> prepare DISPATCH (DBI::db=HASH(0x201b7ed4) rc1/1 @2 g0 imaa201 pid#1953922) at db2Connect.pl line 7 -> prepare for DBD::DB2::db (DBI::db=HASH(0x201b7ed4)~0x201b7e50 'Values CURRENT DATE') thr#200093a8 New 'DBI::st' (for DBD::DB2::st, parent=DBI::db=HASH(0x201b7e50), id=undef) dbih_setup_handle(DBI::st=HASH(0x201b7fa0)=>DBI::st=HASH(0x201b7f34), DBD::DB2::st, 2011fb8c, Null!) dbih_make_com(DBI::db=HASH(0x201b7e50), 201279d8, DBD::DB2::st, 160, 0) thr#200093a8 dbih_setup_attrib(DBI::st=HASH(0x201b7f34), Err, DBI::db=HASH(0x201b7e50)) SCALAR(0x2011fad8) (already defined) dbih_setup_attrib(DBI::st=HASH(0x201b7f34), State, DBI::db=HASH(0x201b7e50)) SCALAR(0x2011fb38) (already defined) dbih_setup_attrib(DBI::st=HASH(0x201b7f34), Errstr, DBI::db=HASH(0x201b7e50)) SCALAR(0x2011fb08) (already defined) dbih_setup_attrib(DBI::st=HASH(0x201b7f34), TraceLevel, DBI::db=HASH(0x201b7e50)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x201b7f34), FetchHashKeyName, DBI::db=HASH(0x201b7e50)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x201b7f34), HandleSetErr, DBI::db=HASH(0x201b7e50)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x201b7f34), HandleError, DBI::db=HASH(0x201b7e50)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x201b7f34), ReadOnly, DBI::db=HASH(0x201b7e50)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x201b7f34), Profile, DBI::db=HASH(0x201b7e50)) undef (not defined) dbd_st_prepare'd sql f65537 Values CURRENT DATE fbh 0: '1' , type 91, 10, dsize 10, p0 s12 out: ftype 1, indp 0, bufl 11, rlen 11 <- prepare= DBI::st=HASH(0x201b7fa0) at db2Connect.pl line 7 >> execute DISPATCH (DBI::st=HASH(0x201b7fa0) rc1/1 @1 g0 ima1041 pid#1953922) at db2Connect.pl line 8 -> execute for DBD::DB2::st (DBI::st=HASH(0x201b7fa0)~0x201b7f34) thr#200093a8 <- execute= -1 at db2Connect.pl line 8 >> bind_col DISPATCH (DBI::st=HASH(0x201b7fa0) rc1/1 @3 g0 ima1 pid#1953922) at db2Connect.pl line 11 -> bind_col in DBD::_::st for DBD::DB2::st (DBI::st=HASH(0x201b7fa0)~0x201b7f34 1 SCALAR(0x200d1a30)) thr#200093a8 dbih_setup_fbav alloc for 1 fields dbih_setup_fbav now 1 fields dbih_sth_bind_col 1 => SCALAR(0x200d1a30) Null! <- bind_col= 1 at db2Connect.pl line 11 >> fetch DISPATCH (DBI::st=HASH(0x201b7fa0) rc1/1 @1 g0 ima0 pid#1953922) at db2Connect.pl line 12 -> fetch for DBD::DB2::st (DBI::st=HASH(0x201b7fa0)~0x201b7f34) thr#200093a8 dbd_st_fetch 1 fields 0: rc=0 '2010-08-11' <- fetch= [ '2010-08-11' ] row1 at db2Connect.pl line 12 >> fetch DISPATCH (DBI::st=HASH(0x201b7fa0) rc1/1 @1 g0 ima0 pid#1953922) at db2Connect.pl line 12 -> fetch for DBD::DB2::st (DBI::st=HASH(0x201b7fa0)~0x201b7f34) thr#200093a8 For trace level > 3 - rc = 100 For trace level > 3 - rc = 100 For trace level > 3 - rc = 100 !! info: '' '[IBM][CLI Driver][DB2/AIX64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000 ' (err#0) <- fetch= undef row1 at db2Connect.pl line 12 >> finish DISPATCH (DBI::st=HASH(0x201b7fa0) rc1/1 @1 g0 ima1 pid#1953922) at db2Connect.pl line 13 !! info: '' CLEARED by call to finish method -> finish for DBD::DB2::st (DBI::st=HASH(0x201b7fa0)~0x201b7f34) thr#200093a8 <- finish= 1 at db2Connect.pl line 13 >> disconnect DISPATCH (DBI::db=HASH(0x201b7ed4) rc1/1 @1 g0 ima10c01 pid#1953922) at db2Connect.pl line 14 -> disconnect for DBD::DB2::db (DBI::db=HASH(0x201b7ed4)~0x201b7e50) thr#200093a8 return code after SQLDisconnect 0 return code from Freeing Connect Handle 0 return code Before Freeing ENV Handle 0 return code from Freeing ENV Handle -1 For condition SQL_ERROR - rc =-1 !! info: '' 'Invalid Handle Passed to retrieve Diagnostic Information' (err#0) <- disconnect= '' at db2Connect.pl line 14 -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::DB2::db::errstr <- $DBI::errstr= 'Invalid Handle Passed to retrieve Diagnostic Information' -> $DBI::errstr (&) FETCH from lasth=HASH >> DBD::DB2::db::errstr <- $DBI::errstr= 'Invalid Handle Passed to retrieve Diagnostic Information' >> DESTROY DISPATCH (DBI::st=HASH(0x201b7fa0) rc1/1 @1 g0 ima10004 pid#1953922) <> DESTROY(DBI::st=HASH(0x201b7fa0)) ignored for outer handle (inner DBI::st=HASH(0x201b7f34) has ref cnt 1) >> DESTROY DISPATCH (DBI::st=HASH(0x201b7f34) rc1/1 @1 g0 ima10004 pid#1953922) -> DESTROY for DBD::DB2::st (DBI::st=HASH(0x201b7f34)~INNER) thr#200093a8 info: '' 'Invalid Handle Passed to retrieve Diagnostic Information' (err#0) <- DESTROY= undef DESTROY (dbih_clearcom) (sth 0x201b7f34, com 0x20523328, imp DBD::DB2::st): FLAGS 0x180191: COMSET Warn RaiseError PrintError PrintWarn ERR '' ERRSTR 'Invalid Handle Passed to retrieve Diagnostic Information' PARENT DBI::db=HASH(0x201b7e50) KIDS 0 (0 Active) LongReadLen 32700 NUM_OF_FIELDS 1 NUM_OF_PARAMS 0 dbih_clearcom 0x201b7f34 (com 0x20523328, type 3) done. >> DESTROY DISPATCH (DBI::db=HASH(0x201b7ed4) rc1/1 @1 g0 ima10004 pid#1953922) <> DESTROY(DBI::db=HASH(0x201b7ed4)) ignored for outer handle (inner DBI::db=HASH(0x201b7e50) has ref cnt 1) >> DESTROY DISPATCH (DBI::db=HASH(0x201b7e50) rc1/1 @1 g0 ima10004 pid#1953922) -> DESTROY for DBD::DB2::db (DBI::db=HASH(0x201b7e50)~INNER) thr#200093a8 info: '' 'Invalid Handle Passed to retrieve Diagnostic Information' (err#0) <- DESTROY= undef DESTROY (dbih_clearcom) (dbh 0x201b7e50, com 0x201279d8, imp DBD::DB2::db): FLAGS 0x180391: COMSET Warn RaiseError PrintError PrintWarn AutoCommit ERR '' ERRSTR 'Invalid Handle Passed to retrieve Diagnostic Information' PARENT DBI::dr=HASH(0x201d3588) KIDS 0 (0 Active) LongReadLen 32700 dbih_clearcom 0x201b7e50 (com 0x201279d8, type 2) done. -- DBI::END ($@: , $!: ) >> disconnect_all DISPATCH (DBI::dr=HASH(0x201d3630) rc1/3 @1 g0 ima801 pid#1953922) at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 732 via at db2Connect.pl line 0 !! info: '' CLEARED by call to disconnect_all method -> disconnect_all for DBD::DB2::dr (DBI::dr=HASH(0x201d3630)~0x201d3588) thr#200093a8 <- disconnect_all= 1 at /work/tmp/ujiie/local/perl5_lib/lib/site_perl/5.8.8/aix-thread-multi/DBI.pm line 732 via at db2Connect.pl line 0 ! >> DESTROY DISPATCH (DBI::dr=HASH(0x201d3630) rc1/1 @1 g0 ima10004 pid#1953922) during global destruction ! <> DESTROY(DBI::dr=HASH(0x201d3630)) ignored for outer handle (inner DBI::dr=HASH(0x201d3588) has ref cnt 1) ! >> DESTROY DISPATCH (DBI::dr=HASH(0x201d3588) rc1/1 @1 g0 ima10004 pid#1953922) during global destruction ! -> DESTROY in DBD::_::common for DBD::DB2::dr (DBI::dr=HASH(0x201d3588)~INNER) thr#200093a8 ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (drh 0x201d3588, com 0x2006b778, imp global destruction): FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit PARENT undef KIDS 0 (0 Active) dbih_clearcom 0x201d3588 (com 0x2006b778, type 1) done.