DBI 1.613-ithread default trace level set to 0x0/9 (pid 712952 pi 11000bbf0) at DBI.pm line 275 via db2Connect.pl line 1 -> DBI->connect(dbi:DB2:pdm01p, qooslct, ****, HASH(0x11000d160)) -> DBI->install_driver(DB2) for aix perl=5.008009 pid=712952 ruid=4016 euid=4016 install_driver: DBD::DB2 version 1.79 loaded from /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBD/DB2.pm New 'DBI::dr' (for DBD::DB2::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x110337ee0)=>DBI::dr=HASH(0x110337e00), DBD::DB2::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::DB2::dr, 168, 0) thr#11000bbf0 dbih_setup_attrib(DBI::dr=HASH(0x110337e00), Err, Null!) SCALAR(0x110584db0) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x110337e00), State, Null!) SCALAR(0x11016cdc0) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x110337e00), Errstr, Null!) SCALAR(0x11016ce10) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x110337e00), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x110337e00), FetchHashKeyName, Null!) 'NAME' (already defined) <- install_driver= DBI::dr=HASH(0x110337ee0) >> connect DISPATCH (DBI::dr=HASH(0x110337ee0) rc2/3 @5 g0 ima8001 pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 662 !! warn: 0 CLEARED by call to connect method -> connect for DBD::DB2::dr (DBI::dr=HASH(0x110337ee0)~0x110337e00 'pdm01p' 'qooslct' **** HASH(0x110188140)) thr#11000bbf0 New 'DBI::db' (for DBD::DB2::db, parent=DBI::dr=HASH(0x110337e00), id=undef) dbih_setup_handle(DBI::db=HASH(0x11030bd70)=>DBI::db=HASH(0x11030bcd0), DBD::DB2::db, 1101fcb50, Null!) dbih_make_com(DBI::dr=HASH(0x110337e00), 11004e650, DBD::DB2::db, 176, 0) thr#11000bbf0 dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), Err, DBI::dr=HASH(0x110337e00)) SCALAR(0x1101fcd60) (already defined) dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), State, DBI::dr=HASH(0x110337e00)) SCALAR(0x1101fcde0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), Errstr, DBI::dr=HASH(0x110337e00)) SCALAR(0x1101fcda0) (already defined) dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), TraceLevel, DBI::dr=HASH(0x110337e00)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), FetchHashKeyName, DBI::dr=HASH(0x110337e00)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), HandleSetErr, DBI::dr=HASH(0x110337e00)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), HandleError, DBI::dr=HASH(0x110337e00)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), ReadOnly, DBI::dr=HASH(0x110337e00)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x11030bcd0), Profile, DBI::dr=HASH(0x110337e00)) undef (not defined) connect 'pdm01p', 'qooslct', '****' <- connect= DBI::db=HASH(0x11030bd70) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 662 >> STORE DISPATCH (DBI::db=HASH(0x11030bcd0) rc2/1 @3 g0 ima41c pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 714 -> STORE for DBD::DB2::db (DBI::db=HASH(0x11030bcd0)~INNER 'RaiseError' 1) thr#11000bbf0 STORE DBI::db=HASH(0x11030bcd0) 'RaiseError' => 1 <- STORE= 1 at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 714 >> STORE DISPATCH (DBI::db=HASH(0x11030bcd0) rc2/1 @3 g0 ima41c pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 714 -> STORE for DBD::DB2::db (DBI::db=HASH(0x11030bcd0)~INNER 'PrintError' 1) thr#11000bbf0 STORE DBI::db=HASH(0x11030bcd0) 'PrintError' => 1 <- STORE= 1 at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 714 >> STORE DISPATCH (DBI::db=HASH(0x11030bcd0) rc2/1 @3 g0 ima41c pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 714 -> STORE for DBD::DB2::db (DBI::db=HASH(0x11030bcd0)~INNER 'AutoCommit' 1) thr#11000bbf0 <- STORE= 1 at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 714 >> STORE DISPATCH (DBI::db=HASH(0x11030bcd0) rc2/1 @3 g0 ima41c pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 717 via at db2Connect.pl line 4 -> STORE for DBD::DB2::db (DBI::db=HASH(0x11030bcd0)~INNER 'Username' 'qooslct') thr#11000bbf0 STORE DBI::db=HASH(0x11030bcd0) 'Username' => 'qooslct' <- STORE= 1 at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 717 via at db2Connect.pl line 4 >> FETCH DISPATCH (DBI::db=HASH(0x11030bcd0) rc2/1 @2 g0 ima404 pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 717 <> FETCH= 'qooslct' ('Username' from cache) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 717 >> connected DISPATCH (DBI::db=HASH(0x11030bd70) rc1/1 @5 g0 ima5 pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 723 -> connected in DBD::_::db for DBD::DB2::db (DBI::db=HASH(0x11030bd70)~0x11030bcd0 'dbi:DB2:pdm01p' 'qooslct' '****' HASH(0x11000d160)) thr#11000bbf0 <- connected= undef at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 723 <- connect= DBI::db=HASH(0x11030bd70) >> STORE DISPATCH (DBI::db=HASH(0x11030bcd0) rc2/1 @3 g0 ima41c pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 732 via at db2Connect.pl line 4 -> STORE for DBD::DB2::db (DBI::db=HASH(0x11030bcd0)~INNER 'dbi_connect_closure' CODE(0x110338030)) thr#11000bbf0 STORE DBI::db=HASH(0x11030bcd0) 'dbi_connect_closure' => CODE(0x110338030) <- STORE= 1 at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 732 via at db2Connect.pl line 4 >> prepare DISPATCH (DBI::db=HASH(0x11030bd70) rc1/1 @2 g0 imaa201 pid#712952) at db2Connect.pl line 7 -> prepare for DBD::DB2::db (DBI::db=HASH(0x11030bd70)~0x11030bcd0 'Values CURRENT DATE') thr#11000bbf0 New 'DBI::st' (for DBD::DB2::st, parent=DBI::db=HASH(0x11030bcd0), id=undef) dbih_setup_handle(DBI::st=HASH(0x11030bea0)=>DBI::st=HASH(0x11030be20), DBD::DB2::st, 1101fce50, Null!) dbih_make_com(DBI::db=HASH(0x11030bcd0), 1102f3330, DBD::DB2::st, 272, 0) thr#11000bbf0 dbih_setup_attrib(DBI::st=HASH(0x11030be20), Err, DBI::db=HASH(0x11030bcd0)) SCALAR(0x1101fcd60) (already defined) dbih_setup_attrib(DBI::st=HASH(0x11030be20), State, DBI::db=HASH(0x11030bcd0)) SCALAR(0x1101fcde0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x11030be20), Errstr, DBI::db=HASH(0x11030bcd0)) SCALAR(0x1101fcda0) (already defined) dbih_setup_attrib(DBI::st=HASH(0x11030be20), TraceLevel, DBI::db=HASH(0x11030bcd0)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x11030be20), FetchHashKeyName, DBI::db=HASH(0x11030bcd0)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x11030be20), HandleSetErr, DBI::db=HASH(0x11030bcd0)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x11030be20), HandleError, DBI::db=HASH(0x11030bcd0)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x11030be20), ReadOnly, DBI::db=HASH(0x11030bcd0)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x11030be20), Profile, DBI::db=HASH(0x11030bcd0)) undef (not defined) dbd_st_prepare'd sql f65537 Values CURRENT DATE fbh 0: '1' , type 91, 10, dsize 10, p0 s7 out: ftype 1, indp 0, bufl 11, rlen 11 <- prepare= DBI::st=HASH(0x11030bea0) at db2Connect.pl line 7 >> execute DISPATCH (DBI::st=HASH(0x11030bea0) rc1/1 @1 g0 ima1041 pid#712952) at db2Connect.pl line 8 -> execute for DBD::DB2::st (DBI::st=HASH(0x11030bea0)~0x11030be20) thr#11000bbf0 <- execute= -1 at db2Connect.pl line 8 >> bind_col DISPATCH (DBI::st=HASH(0x11030bea0) rc1/1 @3 g0 ima1 pid#712952) at db2Connect.pl line 11 -> bind_col in DBD::_::st for DBD::DB2::st (DBI::st=HASH(0x11030bea0)~0x11030be20 1 SCALAR(0x110177350)) thr#11000bbf0 dbih_setup_fbav alloc for 1 fields dbih_setup_fbav now 1 fields dbih_sth_bind_col 1 => SCALAR(0x110177350) Null! <- bind_col= 1 at db2Connect.pl line 11 >> fetch DISPATCH (DBI::st=HASH(0x11030bea0) rc1/1 @1 g0 ima0 pid#712952) at db2Connect.pl line 12 -> fetch for DBD::DB2::st (DBI::st=HASH(0x11030bea0)~0x11030be20) thr#11000bbf0 dbd_st_fetch 1 fields 0: rc=0 '2010-08-16' <- fetch= [ '2010-08-16' ] row1 at db2Connect.pl line 12 >> fetch DISPATCH (DBI::st=HASH(0x11030bea0) rc1/1 @1 g0 ima0 pid#712952) at db2Connect.pl line 12 -> fetch for DBD::DB2::st (DBI::st=HASH(0x11030bea0)~0x11030be20) thr#11000bbf0 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(0x11030bea0) rc1/1 @1 g0 ima1 pid#712952) at db2Connect.pl line 13 !! info: '' CLEARED by call to finish method -> finish for DBD::DB2::st (DBI::st=HASH(0x11030bea0)~0x11030be20) thr#11000bbf0 <- finish= 1 at db2Connect.pl line 13 >> disconnect DISPATCH (DBI::db=HASH(0x11030bd70) rc1/1 @1 g0 ima10c01 pid#712952) at db2Connect.pl line 14 -> disconnect for DBD::DB2::db (DBI::db=HASH(0x11030bd70)~0x11030bcd0) thr#11000bbf0 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 0 Returning from disconnect 0 <- disconnect= 1 at db2Connect.pl line 14 >> DESTROY DISPATCH (DBI::st=HASH(0x11030bea0) rc1/1 @1 g0 ima10004 pid#712952) <> DESTROY(DBI::st=HASH(0x11030bea0)) ignored for outer handle (inner DBI::st=HASH(0x11030be20) has ref cnt 1) >> DESTROY DISPATCH (DBI::st=HASH(0x11030be20) rc1/1 @1 g0 ima10004 pid#712952) -> DESTROY for DBD::DB2::st (DBI::st=HASH(0x11030be20)~INNER) thr#11000bbf0 <- DESTROY= undef DESTROY (dbih_clearcom) (sth 0x11030be20, com 0x1107da670, imp DBD::DB2::st): FLAGS 0x180191: COMSET Warn RaiseError PrintError PrintWarn PARENT DBI::db=HASH(0x11030bcd0) KIDS 0 (0 Active) LongReadLen 32700 NUM_OF_FIELDS 1 NUM_OF_PARAMS 0 dbih_clearcom 0x11030be20 (com 0x1107da670, type 3) done. >> DESTROY DISPATCH (DBI::db=HASH(0x11030bd70) rc1/1 @1 g0 ima10004 pid#712952) <> DESTROY(DBI::db=HASH(0x11030bd70)) ignored for outer handle (inner DBI::db=HASH(0x11030bcd0) has ref cnt 1) >> DESTROY DISPATCH (DBI::db=HASH(0x11030bcd0) rc1/1 @1 g0 ima10004 pid#712952) -> DESTROY for DBD::DB2::db (DBI::db=HASH(0x11030bcd0)~INNER) thr#11000bbf0 <- DESTROY= undef DESTROY (dbih_clearcom) (dbh 0x11030bcd0, com 0x1102f3330, imp DBD::DB2::db): FLAGS 0x180391: COMSET Warn RaiseError PrintError PrintWarn AutoCommit PARENT DBI::dr=HASH(0x110337e00) KIDS 0 (0 Active) LongReadLen 32700 dbih_clearcom 0x11030bcd0 (com 0x1102f3330, type 2) done. -- DBI::END ($@: , $!: ) >> disconnect_all DISPATCH (DBI::dr=HASH(0x110337ee0) rc1/3 @1 g0 ima801 pid#712952) at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 740 via at db2Connect.pl line 0 -> disconnect_all for DBD::DB2::dr (DBI::dr=HASH(0x110337ee0)~0x110337e00) thr#11000bbf0 <- disconnect_all= 1 at /work/tmp/ujiie/local/perl5/lib/site_perl/5.8.9/aix-thread-multi-64all/DBI.pm line 740 via at db2Connect.pl line 0 ! >> DESTROY DISPATCH (DBI::dr=HASH(0x110337ee0) rc1/1 @1 g0 ima10004 pid#712952) during global destruction ! <> DESTROY(DBI::dr=HASH(0x110337ee0)) ignored for outer handle (inner DBI::dr=HASH(0x110337e00) has ref cnt 1) ! >> DESTROY DISPATCH (DBI::dr=HASH(0x110337e00) rc1/1 @1 g0 ima10004 pid#712952) during global destruction ! -> DESTROY in DBD::_::common for DBD::DB2::dr (DBI::dr=HASH(0x110337e00)~INNER) thr#11000bbf0 ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (drh 0x110337e00, com 0x11004e650, imp global destruction): FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit PARENT undef KIDS 0 (0 Active) dbih_clearcom 0x110337e00 (com 0x11004e650, type 1) done.