DBI 1.611-nothread default trace level set to 0x0/9 (pid 2714) at DBI.pm line 275 via - line 1 -> DBI->connect(dbi:DB2:tstdb, db2inst1, ****, HASH(0x80628c0)) -> DBI->install_driver(DB2) for solaris perl=5.008004 pid=2714 ruid=1001 euid=1001 install_driver: DBD::DB2 version 1.79 loaded from /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBD/DB2.pm New 'DBI::dr' (for DBD::DB2::dr, parent='', id=undef) dbih_setup_handle(DBI::dr=HASH(0x8093918)=>DBI::dr=HASH(0x81e82b4), DBD::DB2::dr, 0, Null!) dbih_make_com(Null!, 0, DBD::DB2::dr, 100, 0) thr#0 dbih_setup_attrib(DBI::dr=HASH(0x81e82b4), Err, Null!) SCALAR(0x832b2bc) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x81e82b4), State, Null!) SCALAR(0x814fdb8) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x81e82b4), Errstr, Null!) SCALAR(0x814fe0c) (already defined) dbih_setup_attrib(DBI::dr=HASH(0x81e82b4), TraceLevel, Null!) 0 (already defined) dbih_setup_attrib(DBI::dr=HASH(0x81e82b4), FetchHashKeyName, Null!) 'NAME' (already defined) <- install_driver= DBI::dr=HASH(0x8093918) >> connect DISPATCH (DBI::dr=HASH(0x8093918) rc2/3 @5 g0 ima8001 pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 655 !! warn: 0 CLEARED by call to connect method -> connect for DBD::DB2::dr (DBI::dr=HASH(0x8093918)~0x81e82b4 'tstdb' 'db2inst1' **** HASH(0x815dab0)) New 'DBI::db' (for DBD::DB2::db, parent=DBI::dr=HASH(0x81e82b4), id=undef) dbih_setup_handle(DBI::db=HASH(0x81f3e1c)=>DBI::db=HASH(0x81f3d98), DBD::DB2::db, 819401c, Null!) dbih_make_com(DBI::dr=HASH(0x81e82b4), 81a4b30, DBD::DB2::db, 108, 0) thr#0 dbih_setup_attrib(DBI::db=HASH(0x81f3d98), Err, DBI::dr=HASH(0x81e82b4)) SCALAR(0x8196eac) (already defined) dbih_setup_attrib(DBI::db=HASH(0x81f3d98), State, DBI::dr=HASH(0x81e82b4)) SCALAR(0x8196f0c) (already defined) dbih_setup_attrib(DBI::db=HASH(0x81f3d98), Errstr, DBI::dr=HASH(0x81e82b4)) SCALAR(0x8196edc) (already defined) dbih_setup_attrib(DBI::db=HASH(0x81f3d98), TraceLevel, DBI::dr=HASH(0x81e82b4)) 0 (already defined) dbih_setup_attrib(DBI::db=HASH(0x81f3d98), FetchHashKeyName, DBI::dr=HASH(0x81e82b4)) 'NAME' (already defined) dbih_setup_attrib(DBI::db=HASH(0x81f3d98), HandleSetErr, DBI::dr=HASH(0x81e82b4)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x81f3d98), HandleError, DBI::dr=HASH(0x81e82b4)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x81f3d98), ReadOnly, DBI::dr=HASH(0x81e82b4)) undef (not defined) dbih_setup_attrib(DBI::db=HASH(0x81f3d98), Profile, DBI::dr=HASH(0x81e82b4)) undef (not defined) connect 'tstdb', 'db2inst1', '01testdb' <- connect= DBI::db=HASH(0x81f3e1c) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 655 >> STORE DISPATCH (DBI::db=HASH(0x81f3d98) rc2/1 @3 g0 ima41c pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 707 -> STORE for DBD::DB2::db (DBI::db=HASH(0x81f3d98)~INNER 'RaiseError' 1) STORE DBI::db=HASH(0x81f3d98) 'RaiseError' => 1 <- STORE= 1 at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 707 >> STORE DISPATCH (DBI::db=HASH(0x81f3d98) rc2/1 @3 g0 ima41c pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 707 -> STORE for DBD::DB2::db (DBI::db=HASH(0x81f3d98)~INNER 'PrintError' 1) STORE DBI::db=HASH(0x81f3d98) 'PrintError' => 1 <- STORE= 1 at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 707 >> STORE DISPATCH (DBI::db=HASH(0x81f3d98) rc2/1 @3 g0 ima41c pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 707 -> STORE for DBD::DB2::db (DBI::db=HASH(0x81f3d98)~INNER 'AutoCommit' 1) <- STORE= 1 at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 707 >> STORE DISPATCH (DBI::db=HASH(0x81f3d98) rc2/1 @3 g0 ima41c pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 710 via at - line 4 -> STORE for DBD::DB2::db (DBI::db=HASH(0x81f3d98)~INNER 'Username' 'db2inst1') STORE DBI::db=HASH(0x81f3d98) 'Username' => 'db2inst1' <- STORE= 1 at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 710 via at - line 4 >> FETCH DISPATCH (DBI::db=HASH(0x81f3d98) rc2/1 @2 g0 ima404 pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 710 <> FETCH= 'db2inst1' ('Username' from cache) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 710 >> connected DISPATCH (DBI::db=HASH(0x81f3e1c) rc1/1 @5 g0 ima5 pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 716 -> connected in DBD::_::db for DBD::DB2::db (DBI::db=HASH(0x81f3e1c)~0x81f3d98 'dbi:DB2:tstdb' 'db2inst1' '01testdb' HASH(0x80628c0)) <- connected= undef at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 716 <- connect= DBI::db=HASH(0x81f3e1c) >> STORE DISPATCH (DBI::db=HASH(0x81f3d98) rc2/1 @3 g0 ima41c pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 725 via at - line 4 -> STORE for DBD::DB2::db (DBI::db=HASH(0x81f3d98)~INNER 'dbi_connect_closure' CODE(0x8093a5c)) STORE DBI::db=HASH(0x81f3d98) 'dbi_connect_closure' => CODE(0x8093a5c) <- STORE= 1 at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 725 via at - line 4 >> prepare DISPATCH (DBI::db=HASH(0x81f3e1c) rc1/1 @2 g0 imaa201 pid#2714) at - line 7 -> prepare for DBD::DB2::db (DBI::db=HASH(0x81f3e1c)~0x81f3d98 'Values CURRENT DATE') New 'DBI::st' (for DBD::DB2::st, parent=DBI::db=HASH(0x81f3d98), id=undef) dbih_setup_handle(DBI::st=HASH(0x81f5104)=>DBI::st=HASH(0x81f3e7c), DBD::DB2::st, 8196f84, Null!) dbih_make_com(DBI::db=HASH(0x81f3d98), 832c758, DBD::DB2::st, 168, 0) thr#0 dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), Err, DBI::db=HASH(0x81f3d98)) SCALAR(0x8196eac) (already defined) dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), State, DBI::db=HASH(0x81f3d98)) SCALAR(0x8196f0c) (already defined) dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), Errstr, DBI::db=HASH(0x81f3d98)) SCALAR(0x8196edc) (already defined) dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), TraceLevel, DBI::db=HASH(0x81f3d98)) 0 (already defined) dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), FetchHashKeyName, DBI::db=HASH(0x81f3d98)) 'NAME' (already defined) dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), HandleSetErr, DBI::db=HASH(0x81f3d98)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), HandleError, DBI::db=HASH(0x81f3d98)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), ReadOnly, DBI::db=HASH(0x81f3d98)) undef (not defined) dbih_setup_attrib(DBI::st=HASH(0x81f3e7c), Profile, DBI::db=HASH(0x81f3d98)) undef (not defined) dbd_st_prepare'd sql f65537 Values CURRENT DATE fbh 0: '1' , type 91, 10, dsize 10, p0 s41 out: ftype 1, indp 0, bufl 41, rlen 41 <- prepare= DBI::st=HASH(0x81f5104) at - line 7 >> execute DISPATCH (DBI::st=HASH(0x81f5104) rc1/1 @1 g0 ima1041 pid#2714) at - line 8 -> execute for DBD::DB2::st (DBI::st=HASH(0x81f5104)~0x81f3e7c) <- execute= -1 at - line 8 >> bind_col DISPATCH (DBI::st=HASH(0x81f5104) rc1/1 @3 g0 ima1 pid#2714) at - line 11 -> bind_col in DBD::_::st for DBD::DB2::st (DBI::st=HASH(0x81f5104)~0x81f3e7c 1 SCALAR(0x8154d34)) dbih_setup_fbav alloc for 1 fields dbih_setup_fbav now 1 fields dbih_sth_bind_col 1 => SCALAR(0x8154d34) Null! <- bind_col= 1 at - line 11 >> fetch DISPATCH (DBI::st=HASH(0x81f5104) rc1/1 @1 g0 ima0 pid#2714) at - line 12 -> fetch for DBD::DB2::st (DBI::st=HASH(0x81f5104)~0x81f3e7c) dbd_st_fetch 1 fields 0: rc=0 '2010-08-09' <- fetch= [ '2010-08-09' ] row1 at - line 12 >> fetch DISPATCH (DBI::st=HASH(0x81f5104) rc1/1 @1 g0 ima0 pid#2714) at - line 12 -> fetch for DBD::DB2::st (DBI::st=HASH(0x81f5104)~0x81f3e7c) For trace level > 3 - rc = 100 For trace level > 3 - rc = 100 For trace level > 3 - rc = 100 !! info: '' '[IBM][CLI Driver][DB2/LINUXX8664] 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 - line 12 >> finish DISPATCH (DBI::st=HASH(0x81f5104) rc1/1 @1 g0 ima1 pid#2714) at - line 13 !! info: '' CLEARED by call to finish method -> finish for DBD::DB2::st (DBI::st=HASH(0x81f5104)~0x81f3e7c) <- finish= 1 at - line 13 >> disconnect DISPATCH (DBI::db=HASH(0x81f3e1c) rc1/1 @1 g0 ima10c01 pid#2714) at - line 14 -> disconnect for DBD::DB2::db (DBI::db=HASH(0x81f3e1c)~0x81f3d98) return code after SQLDisconnect 0 return code from Freeing Connect 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 - 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(0x81f5104) rc1/1 @1 g0 ima10004 pid#2714) <> DESTROY(DBI::st=HASH(0x81f5104)) ignored for outer handle (inner DBI::st=HASH(0x81f3e7c) has ref cnt 1) >> DESTROY DISPATCH (DBI::st=HASH(0x81f3e7c) rc1/1 @1 g0 ima10004 pid#2714) -> DESTROY for DBD::DB2::st (DBI::st=HASH(0x81f3e7c)~INNER) info: '' 'Invalid Handle Passed to retrieve Diagnostic Information' (err#0) <- DESTROY= undef DESTROY (dbih_clearcom) (sth 0x81f3e7c, com 0x833abf8, imp DBD::DB2::st): FLAGS 0x180191: COMSET Warn RaiseError PrintError PrintWarn ERR '' ERRSTR 'Invalid Handle Passed to retrieve Diagnostic Information' PARENT DBI::db=HASH(0x81f3d98) KIDS 0 (0 Active) LongReadLen 32700 NUM_OF_FIELDS 1 NUM_OF_PARAMS 0 dbih_clearcom 0x81f3e7c (com 0x833abf8, type 3) done. >> DESTROY DISPATCH (DBI::db=HASH(0x81f3e1c) rc1/1 @1 g0 ima10004 pid#2714) <> DESTROY(DBI::db=HASH(0x81f3e1c)) ignored for outer handle (inner DBI::db=HASH(0x81f3d98) has ref cnt 1) >> DESTROY DISPATCH (DBI::db=HASH(0x81f3d98) rc1/1 @1 g0 ima10004 pid#2714) -> DESTROY for DBD::DB2::db (DBI::db=HASH(0x81f3d98)~INNER) info: '' 'Invalid Handle Passed to retrieve Diagnostic Information' (err#0) <- DESTROY= undef DESTROY (dbih_clearcom) (dbh 0x81f3d98, com 0x832c758, 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(0x81e82b4) KIDS 0 (0 Active) LongReadLen 32700 dbih_clearcom 0x81f3d98 (com 0x832c758, type 2) done. -- DBI::END ($@: , $!: ) >> disconnect_all DISPATCH (DBI::dr=HASH(0x8093918) rc1/3 @1 g0 ima801 pid#2714) at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 734 via at - line 0 !! info: '' CLEARED by call to disconnect_all method -> disconnect_all for DBD::DB2::dr (DBI::dr=HASH(0x8093918)~0x81e82b4) <- disconnect_all= 1 at /usr/perl5/site_perl/5.8.4/i86pc-solaris-64int/DBI.pm line 734 via at - line 0 ! >> DESTROY DISPATCH (DBI::dr=HASH(0x81e82b4) rc1/1 @1 g0 ima10004 pid#2714) during global destruction ! -> DESTROY in DBD::_::common for DBD::DB2::dr (DBI::dr=HASH(0x81e82b4)~INNER) ! <- DESTROY= undef during global destruction DESTROY (dbih_clearcom) (drh 0x8093918, com 0x81a4b30, imp global destruction): FLAGS 0x100215: COMSET Active Warn PrintWarn AutoCommit PARENT undef KIDS 0 (0 Active) dbih_clearcom 0x8093918 (com 0x81a4b30, type 1) done. ! >> DESTROY DISPATCH (DBI::dr=HASH(0x8093918) rc1/1 @1 g0 ima10004 pid#2714) during global destruction ! <> DESTROY for DBI::dr=HASH(0x8093918) ignored (inner handle gone)