zOs/WK/PLANINFO
$#@
$=subsys=DbAF
call sqlConnect $subsys
call sqlPreOpen 1,
,"select t.creator, t.dbname, s.encoding_scheme, t.colCount, c.name" ,
", date(t.alteredTS)" ,
"from sysibm.sysTables t",
"join sysibm.sysTableSpace s",
"on t.dbName=s.dbName and t.tsName = s.name",
"join sysibm.sysColumns c",
"on c.tbCreator=t.creator and c.tbName = t.name",
"and c.colNo = t.colCount",
"where (t.creator like 'C%' or t.creator like '%')" ,
"and t.name = 'PLAN_TABLE'",
"order by t.alteredTs desc"
$$- sysvar(sysnode) $subsys date(s) time()
do while sqlFetchInto(1, ':cre, :db, :enc, :colCnt, :col, :alDa')
if colCnt >= 46 then
biTiCol = "value(max(bind_time), '0001-01-01-00.00.00')"
else
biTiCol = "'---'"
m.sqlRetOk = '*'
res = sqlPreAllCl(2,
,"select count(*)," biTiCol ,
"from" cre".plan_table", st, ":pCnt, :pTst")
if res < 0 then do
pCnt = '--'res
pTst = 'sqlCode'
end
else if res <> 1 then
call err res "rows from count(*)" cre".plan_table"
res = sqlPreAllCl(2, "select count(*)",
"from" cre".F2Plan_table", st, ":fCnt")
if res < 0 then
fCnt = '--'res
else if res <> 1 then
call err res "rows from count(*)" cre".f2Plan_table"
$$- left(cre, 8) left(db, 8) enc $*+
left(colCnt alDa col, 22)right(pCnt, 7) $*+
'to' left(pTst, 10) "f2Plan" fCnt "rows"
m.sqlRetOk = ''
end
$#out 20120329 09:35:44
RZ1 DbAF 20120329 09:35:45
A223522 DB2PLAN U 64 22.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A581755 DB2PLAN U 64 21.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A730200 DB2PLAN U 64 21.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A540769 DB2PLAN U 64 21.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A174610 DB2PLAN U 64 20.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
F602687 DB2PLAN U 59 20.03.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F475812 DB2PLAN U 59 20.03.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A558920 DB2PLAN U 59 20.03.2012 PARENT_P 4 to 2012-03-20 f2Plan 0 rows
S107887 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
S107189 DB2PLAN U 64 19.03.2012 MERGN 13 to 2012-03-08 f2Plan 0 rows
S103931 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
S101869 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
CMNBATCH DB2PLAN U 64 19.03.2012 MERGN 1963309 to 2012-03-29 f2Plan ---204 ro
S100447 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
S100006 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A230582 DB2PLAN U 59 06.03.2012 PARENT_P 89 to 2012-03-16 f2Plan 0 rows
A588168 DB2PLAN U 59 15.02.2012 PARENT_P 2 to 2012-02-15 f2Plan 2 rows
A218042 DB2PLAN U 59 15.02.2012 PARENT_P 2 to 2012-02-15 f2Plan 3 rows
DB2ADMIN DB2PLAN U 59 10.02.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A351153 DB2PLAN U 64 30.01.2012 MERGN 217 to 2012-01-12 f2Plan 0 rows
DB2OE AOCQTDB U 64 30.01.2012 MERGN 0 to 0001-01-01 f2Plan ---204 ro
DB2OSC AOCQTDB U 64 30.01.2012 MERGN 1280 to 2012-03-16 f2Plan ---204 ro
A754048 DB2PLAN U 64 27.01.2012 MERGN 12 to 2012-02-08 f2Plan ---204 ro
A828386 DB2PLAN U 59 24.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A715414 DB2PLAN E 59 24.01.2012 PARENT_P 5 to 2012-01-24 f2Plan 0 rows
A422686 DB2PLAN U 59 24.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F597926 DB2PLAN E 59 23.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A595055 DB2PLAN E 59 17.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A662172 DB2PLAN U 59 12.01.2012 PARENT_P 418 to 2012-01-12 f2Plan ---204 ro
F570617 DB2PLAN U 59 03.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A313703 DB2PLAN U 59 28.12.2011 PARENT_P 7 to 2011-12-29 f2Plan 0 rows
F718952 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
X979074 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F996967 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F985779 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F975595 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F940771 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F873288 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F731398 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F701065 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F633341 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F631527 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F629042 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F616625 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F616617 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F614967 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F607057 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F604252 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F600435 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F587242 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F578271 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F578255 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F572296 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F558781 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F551132 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F547534 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F546562 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F542850 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F540769 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F540657 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F540270 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F535609 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F531557 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F526782 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F524941 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F496361 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F492730I DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F473828 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F403358 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F383764 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F377760 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F326930 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F325400 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F306871 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F305976 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F293923 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F278290 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F273764 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F263146 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F262061 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F260200 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F256274 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F248700 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F247743 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F240889 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F227955 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F222112 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F192213 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
F151800 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
F107992 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
F100150 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
EXTRSQL DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
B223522 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A981516 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A979074 DB2PLAN U 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A961140 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A960926 DB2PLAN E 58 28.12.2011 STMTTOKE 8 to 2011-12-28 f2Plan 0 rows
A955213 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A951242 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A927198 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A919233 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A918249 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan ---204 ro
A915246 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A914227 DB2PLAN U 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A892564 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A850128 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A837210 DB2PLAN E 59 28.12.2011 PARENT_P 35 to 2012-01-18 f2Plan 110 rows
A736627 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A705273 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A666308 DB2PLAN U 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A635743 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A632051 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A629518 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A629484 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A626217 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A621463 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A620076 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A596175 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A589446 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A587951 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A586033 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A577182 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A572942 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A572695 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A570617 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A563742 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A563637 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A559315 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A541931 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A532800 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A532359 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A532022 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A530267 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A524624 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524551 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524500 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524438 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524365 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524314 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524292 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523539 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523482 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523385 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523318 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523288 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A522582 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A521072 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A512928 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A512707 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A511115 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A510860 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A510291 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A510178 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A509137 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A508938 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A508742 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A506455 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A506375 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A497088 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A487481 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A485020 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A474375 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A472348 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A472313 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A471902 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A467700 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A465791 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A462253 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A454262 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A424475 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A406205 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A394898 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A390880 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A385879 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A373734 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A370464 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A366335 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A361694 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A359673 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A351230 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A349155 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A347067 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A346474 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A345745 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A344129 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A342480 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A337145 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A331647 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A327913 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A323691 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A317296 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A317210 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A313483 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A313291 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A309200 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A281305 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A276719 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A274961 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A268813 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A267272 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A267256 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A267248 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A266578 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A258214 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A255371 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A254812 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A249894 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A244058 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A242407 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A230698 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A227440 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A223569 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A223348 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A223062 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A222384 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A217534 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A215813 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A197300 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A177397 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A169890 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A167669 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A167452 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A167138 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A166573 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A164392 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A156586 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A155853 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A152110 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A139274 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A118753 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A116231 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A523593 AU03A1A U 59 22.08.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
GDB0178 DGDB0178 E 59 08.07.2011 PARENT_P 3 to 2011-07-12 f2Plan ---204 ro
A543397 DA543397 U 59 11.05.2011 PARENT_P 3 to 2011-05-11 f2Plan 1 rows
A677016 DA677016 U 59 03.05.2011 PARENT_P 8 to 2011-05-03 f2Plan 0 rows
A623447 DA623447 E 59 27.01.2011 PARENT_P 5 to 2011-02-02 f2Plan ---204 ro
A700522 DA700522 E 58 04.11.2010 STMTTOKE 3 to 2010-11-04 f2Plan 0 rows
F288874 VV29A1X E 59 20.08.2010 PARENT_P 120 to 2010-12-09 f2Plan ---204 ro
A168658 DA168658 U 59 25.06.2010 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A230450 DA230450 E 59 24.03.2010 PARENT_P 319 to 2012-03-17 f2Plan 10 rows
A273818 DA273818 U 59 04.03.2010 PARENT_P 26 to 2010-06-08 f2Plan ---204 ro
F383353 DF383353 E 58 22.01.2010 STMTTOKE 5 to 2012-03-07 f2Plan ---204 ro
A188662 DA188662 U 59 13.01.2010 PARENT_P 19 to 2010-01-13 f2Plan 5 rows
A377027 DA377027 U 59 21.10.2009 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
F464418 DF464418 U 59 24.08.2009 PARENT_P 3 to 2011-02-03 f2Plan 3 rows
A484692 DSQDBDEF U 59 06.08.2009 PARENT_P 1073 to 2011-02-17 f2Plan 595 rows
ANLUSER1 IDTANL00 E 59 15.07.2009 PARENT_P 10 to 2011-11-11 f2Plan ---204 ro
A651777 DA651777 E 58 25.03.2009 STMTTOKE 77 to 2011-01-06 f2Plan 0 rows
A426625 DA426625 E 58 26.05.2008 STMTTOKE 449 to 2009-05-26 f2Plan 114 rows
GDB0275 DGDB0275 E 49 08.10.2007 PRIMARY_ 8 to 2007-10-09 f2Plan ---204 ro
A618725 DA618725 E 58 31.07.2007 STMTTOKE 17780 to 2010-11-29 f2Plan ---204 ro
A533734 DSNDB04 E 58 19.10.2006 STMTTOKE 4 to 2008-02-08 f2Plan ---204 ro
A634011 DSNDB04 E 58 19.10.2006 STMTTOKE 1 to 2006-10-20 f2Plan ---204 ro
GOWM200 DGOWM200 E 58 18.10.2006 STMTTOKE 0 to 0001-01-01 f2Plan ---204 ro
A108875 SV02A1A E 58 12.09.2006 STMTTOKE 2 to 2010-02-11 f2Plan 0 rows
GDB0135 DGDB0135 E 46 17.02.2006 BIND_TIM 5 to 2006-02-17 f2Plan ---204 ro
A547666 WN01A1A E 51 11.05.2005 TABLE_TY 1 to 2005-12-09 f2Plan 15 rows
A215396 WA01A1A E 46 11.12.2003 BIND_TIM 6 to 2003-12-11 f2Plan 9 rows
OPTHINT DS100447 E 51 03.12.2003 TABLE_TY 28 to 2004-12-13 f2Plan ---204 ro
X002151 DX002151 E 46 13.06.2003 BIND_TIM 5 to 2003-06-13 f2Plan 3 rows
X002127 DX002127 E 46 13.06.2003 BIND_TIM 3 to 2003-06-13 f2Plan 2 rows
A459429 DA459429 E 51 24.04.2003 TABLE_TY 2 to 2003-04-24 f2Plan ---204 ro
A573701 WA01A1A E 46 25.02.2002 BIND_TIM 634 to 2007-09-05 f2Plan 727 rows
W015660 DW015660 E 46 30.07.2001 BIND_TIM ---904 to sqlCode f2Plan ---904 ro
F890588 DHPSD53 E 46 19.07.2001 BIND_TIM 4 to 2001-07-19 f2Plan 5 rows
A830011 DA830011 E 46 26.09.2000 BIND_TIM 3 to 2000-09-26 f2Plan ---204 ro
T022527 DT022527 E 46 26.11.1999 BIND_TIM 24 to 2000-09-20 f2Plan 1 rows
A829269 DA829269 E 43 27.08.1997 IBM_SERV 32 to --- f2Plan 55 rows
A449415 DA449415 E 34 09.05.1995 JOIN_PGR 13 to --- f2Plan ---204 ro
A516058 DA516058 E 34 08.03.1995 JOIN_PGR 10 to --- f2Plan ---204 ro
A620181 DA620181 E 30 04.01.1994 COLLID 48 to --- f2Plan ---204 ro
$#out 20120329 09:30:13
RZ1 DbtF 20120329 09:30:14
CMNBATCH DB2PLAN U 64 22.03.2012 MERGN 7321668 to 2012-03-29 f2Plan ---204 ro
A174610 DB2PLAN U 64 20.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A730200 DB2PLAN U 59 20.03.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A581755 DB2PLAN U 59 20.03.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A558920 DB2PLAN U 59 20.03.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A540769 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A351153 DB2PLAN U 64 13.03.2012 MERGN 6 to 2010-12-20 f2Plan 1 rows
A230582 DSQDBDEF U 59 05.03.2012 PARENT_P 83 to 2012-03-26 f2Plan 32 rows
A559315 DB2PLAN U 64 02.03.2012 MERGN 2 to 2012-03-02 f2Plan ---204 ro
A602687 DB2PLAN U 59 29.02.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A715414 DB2PLAN E 59 24.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A595055 DB2PLAN E 59 17.01.2012 PARENT_P 4 to 2012-01-17 f2Plan 0 rows
A313703 DB2PLAN U 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A223522 AU01A1T E 59 26.09.2011 PARENT_P 11 to 2011-09-26 f2Plan ---204 ro
A754048 DB2PLAN U 59 21.09.2011 PARENT_P 6 to 2012-02-03 f2Plan ---204 ro
A510178 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A510291 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A511115 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523318 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524624 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524551 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524500 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524438 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524365 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524314 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524292 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523539 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523482 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523385 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523288 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A521072 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A512928 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A512707 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A510860 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A509137 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A508742 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A506375 DB2PLAN E 59 18.07.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A242407 DB2PLAN E 59 09.06.2011 PARENT_P 29 to 2011-11-07 f2Plan 0 rows
A677016 DB2PLAN E 59 03.05.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A626217 DB2PLAN E 59 15.03.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A349155 DB2PLAN E 59 15.03.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A313291 DB2PLAN E 59 15.03.2011 PARENT_P 53 to 2011-04-06 f2Plan 60 rows
A705273 DB2PLAN E 59 15.03.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A472348 DB2PLAN E 59 15.03.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A736627 DB2PLAN E 59 15.03.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A267248 DB2PLAN E 59 15.03.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A837210 DB2PLAN E 59 15.03.2011 PARENT_P 573 to 2012-01-18 f2Plan 1009 rows
A623447 DA623447 E 59 25.01.2011 PARENT_P 53 to 2011-01-25 f2Plan ---204 ro
A454262 DB2PLAN E 59 10.01.2011 PARENT_P 1 to 2011-01-10 f2Plan 0 rows
A422686 DB2PLAN E 59 29.12.2010 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A850128 DB2PLAN E 59 29.11.2010 PARENT_P 11 to 2011-01-21 f2Plan 6 rows
A588168 DB2PLAN E 59 24.11.2010 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A373734 DB2PLAN E 59 23.11.2010 PARENT_P 3 to 2010-11-25 f2Plan 141 rows
A274961 DB2PLAN E 59 05.11.2010 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A485020 DB2PLAN E 59 02.11.2010 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A132482 DSQDBDEF U 59 04.10.2010 PARENT_P 48 to 2010-10-04 f2Plan 11 rows
A309200 DB2PLAN E 59 21.07.2010 PARENT_P 74 to 2010-07-28 f2Plan 63 rows
A273818 DB2PLAN E 59 11.06.2010 PARENT_P 1 to 2011-12-22 f2Plan 0 rows
A406205 DB2PLAN E 59 20.05.2010 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A230698 DB2PLAN E 59 15.03.2010 PARENT_P 32 to 2010-06-14 f2Plan 0 rows
A467352 DSQDBDEF U 59 03.02.2010 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A532359 DB2PLAN E 59 25.01.2010 PARENT_P 6035 to 2011-09-20 f2Plan 9768 rows
A323691 DB2PLAN E 59 16.12.2009 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A351230 DB2PLAN E 59 16.12.2009 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A635743 DB2PLAN E 59 28.10.2009 PARENT_P 4 to 2011-01-21 f2Plan 0 rows
A342480 DB2PLAN E 59 28.10.2009 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A543397 DB2PLAN E 59 23.10.2009 PARENT_P 19 to 2011-08-05 f2Plan 17 rows
A621463 DB2PLAN E 58 20.10.2009 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A377027 DB2PLAN E 58 20.10.2009 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A651777 DB2PLAN E 58 07.10.2009 STMTTOKE 48 to 2010-11-03 f2Plan 0 rows
A484692 DSQDBDEF U 59 30.07.2009 PARENT_P 406 to 2011-07-12 f2Plan 218 rows
A223569 DB2PLAN E 58 28.07.2009 STMTTOKE 8 to 2009-07-28 f2Plan 0 rows
A927198 DB2PLAN E 59 02.06.2009 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A267272 DB2PLAN E 59 02.06.2009 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
ANLUSER1 IDTANL00 E 59 18.05.2009 PARENT_P 3 to 2012-01-03 f2Plan ---204 ro
A218042 DB2PLAN E 58 14.04.2009 STMTTOKE 67 to 2009-04-21 f2Plan 0 rows
A629518 DB2PLAN E 58 17.03.2009 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A472313 DB2PLAN E 58 04.03.2009 STMTTOKE 13 to 2011-01-26 f2Plan 0 rows
A327913 DB2PLAN E 58 10.02.2009 STMTTOKE 82 to 2009-03-31 f2Plan 27 rows
A666308 DB2PLAN U 59 05.02.2009 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A254812 DB2PLAN E 59 04.02.2009 PARENT_P 4 to 2011-02-17 f2Plan ---204 ro
A892564 DB2PLAN E 58 26.01.2009 STMTTOKE 15 to 2009-06-02 f2Plan 68 rows
A914227 DB2PLAN U 59 16.12.2008 PARENT_P 6 to 2008-12-16 f2Plan ---204 ro
A828386 DB2PLAN U 59 24.11.2008 PARENT_P 1 to 2008-11-24 f2Plan ---204 ro
A268813 DB2PLAN E 58 13.11.2008 STMTTOKE 9 to 2008-04-17 f2Plan 0 rows
A979074 DB2PLAN U 59 12.11.2008 PARENT_P 34 to 2009-06-29 f2Plan ---204 ro
A234579 DB2PLAN E 58 12.11.2008 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A347067 DB2PLAN E 58 24.10.2008 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A215813 DB2PLAN E 58 03.09.2008 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A266578 DB2PLAN E 58 28.08.2008 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A116231 DB2PLAN E 58 06.08.2008 STMTTOKE 202 to 2008-08-22 f2Plan 278 rows
A223348 DB2PLAN E 58 06.08.2008 STMTTOKE 1322 to 2009-10-02 f2Plan 1818 rows
A223062 DB2PLAN E 58 10.07.2008 STMTTOKE 7 to 2010-08-12 f2Plan 0 rows
A197300 DB2PLAN E 58 10.07.2008 STMTTOKE 39 to 2010-03-18 f2Plan 148 rows
A394898 DB2PLAN E 58 22.05.2008 STMTTOKE 34 to 2011-12-29 f2Plan 0 rows
A960926 DB2PLAN E 58 11.01.2008 STMTTOKE 16 to 2012-01-03 f2Plan 0 rows
A244058 DB2PLAN E 58 06.06.2007 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A155853 DB2PLAN E 58 28.02.2007 STMTTOKE 4 to 2007-02-28 f2Plan 4 rows
A467700 DB2PLAN E 58 13.02.2007 STMTTOKE 1 to 2007-02-13 f2Plan 0 rows
A317296 DB2PLAN E 58 12.02.2007 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A541931 DB2PLAN E 58 12.02.2007 STMTTOKE 7 to 2008-09-22 f2Plan 0 rows
A532022 DB2PLAN E 58 08.01.2007 STMTTOKE 421 to 2012-01-25 f2Plan 283 rows
A918249 DB2PLAN E 58 13.12.2006 STMTTOKE 0 to 0001-01-01 f2Plan ---204 ro
A587951 DB2PLAN E 58 27.10.2006 STMTTOKE 295 to 2006-12-07 f2Plan 0 rows
A390880 DB2PLAN E 58 25.10.2006 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A919233 DB2PLAN E 58 18.10.2006 STMTTOKE 6 to 2005-10-26 f2Plan 6 rows
A267256 DB2PLAN E 58 16.10.2006 STMTTOKE 11 to 2011-11-10 f2Plan 6 rows
A359673 DB2PLAN E 51 05.10.2006 TABLE_TY 2 to 2006-10-06 f2Plan 0 rows
A276719 DB2PLAN E 58 23.08.2006 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A281305 DB2PLAN E 51 10.08.2006 TABLE_TY 6 to 2006-08-10 f2Plan 1 rows
A337145 DB2PLAN E 51 02.06.2006 TABLE_TY 24120 to 2010-09-03 f2Plan 20245 row
A632051 DB2PLAN E 51 21.12.2005 TABLE_TY 22 to 2008-06-23 f2Plan 6 rows
A629484 DB2PLAN E 51 21.12.2005 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A465791 DB2PLAN E 51 21.12.2005 TABLE_TY 3 to 2005-12-23 f2Plan 3 rows
A620076 DB2PLAN E 51 06.12.2005 TABLE_TY 26 to 2006-04-03 f2Plan 0 rows
A577182 DB2PLAN E 51 06.12.2005 TABLE_TY 1 to 2005-12-09 f2Plan 0 rows
A474375 DB2PLAN E 51 06.12.2005 TABLE_TY 73 to 2006-11-29 f2Plan 0 rows
A955213 DB2PLAN E 51 06.12.2005 TABLE_TY 3 to 2006-03-10 f2Plan 0 rows
A258214 DB2PLAN E 51 06.12.2005 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A177397 DB2PLAN E 51 06.12.2005 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A346474 DB2PLAN E 51 06.12.2005 TABLE_TY 8 to 2006-02-24 f2Plan 0 rows
A152110 DB2PLAN E 51 06.12.2005 TABLE_TY 4 to 2006-03-27 f2Plan 0 rows
A255371 DB2PLAN E 51 06.12.2005 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A522582 DB2PLAN E 51 06.12.2005 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A915246 DB2PLAN E 51 06.12.2005 TABLE_TY 8 to 2005-12-14 f2Plan 0 rows
A595187 DSQDBDEF E 51 06.12.2005 TABLE_TY 75 to 2005-12-09 f2Plan 88 rows
A167274 DA167274 E 58 17.11.2005 STMTTOKE 16 to 2005-11-17 f2Plan ---204 ro
A586033 DB2PLAN E 51 07.11.2005 TABLE_TY 7 to 2006-02-24 f2Plan ---204 ro
A222384 DB2PLAN E 51 04.11.2005 TABLE_TY 1 to 2005-11-08 f2Plan 0 rows
A981516 DB2PLAN E 51 14.10.2005 TABLE_TY 11 to 2006-04-03 f2Plan 0 rows
A508938 DB2PLAN E 51 05.10.2005 TABLE_TY 16 to 2005-12-06 f2Plan 15 rows
A317210 DB2PLAN E 51 07.09.2005 TABLE_TY 9 to 2009-10-30 f2Plan 0 rows
A462253 DB2PLAN E 51 11.07.2005 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A385879 DB2PLAN E 51 24.06.2005 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A961140 DB2PLAN E 51 22.04.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A596175 DB2PLAN E 51 22.04.2005 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A345745 DB2PLAN E 51 22.04.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A156586 DB2PLAN E 51 20.04.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A487481 DB2PLAN E 51 10.03.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A167669 DB2PLAN E 51 10.03.2005 TABLE_TY 40 to 2010-01-20 f2Plan ---204 ro
A370464 DB2PLAN E 51 14.02.2005 TABLE_TY 53 to 2007-09-12 f2Plan ---204 ro
A532800 DB2PLAN E 51 19.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A951242 DB2PLAN E 51 18.01.2005 TABLE_TY 13 to 2006-04-03 f2Plan 0 rows
A572942 DB2PLAN E 51 18.01.2005 TABLE_TY 3 to 2006-03-10 f2Plan 0 rows
A572695 DB2PLAN E 51 18.01.2005 TABLE_TY 4 to 2005-12-09 f2Plan 0 rows
A547666 DB2PLAN E 51 18.01.2005 TABLE_TY 2 to 2006-04-03 f2Plan 2 rows
A530267 DB2PLAN E 51 18.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A506455 DB2PLAN E 51 18.01.2005 TABLE_TY 64 to 2011-12-13 f2Plan 47 rows
A471902 DB2PLAN E 51 18.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A361694 DB2PLAN E 51 18.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A313483 DB2PLAN E 51 18.01.2005 TABLE_TY 46 to 2006-03-27 f2Plan 0 rows
A227440 DB2PLAN E 51 18.01.2005 TABLE_TY 50 to 2006-03-27 f2Plan 0 rows
A167452 DB2PLAN E 51 18.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A118753 DB2PLAN E 51 18.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A533734 DB2PLAN E 51 18.01.2005 TABLE_TY 1 to 2008-03-12 f2Plan ---204 ro
A169890 DB2PLAN E 51 17.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A563742 DB2PLAN E 51 11.01.2005 TABLE_TY 10 to 2007-02-08 f2Plan ---204 ro
A139274 DB2PLAN E 51 05.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A563637 DB2PLAN E 51 05.01.2005 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A570617 DB2PLAN E 51 05.01.2005 TABLE_TY 12 to 2006-02-23 f2Plan ---204 ro
A344129 DB2PLAN E 51 13.10.2004 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A217534 DB2PLAN E 51 06.09.2004 TABLE_TY 57 to 2007-01-23 f2Plan ---204 ro
A464418 BE01A1T E 51 18.08.2004 TABLE_TY 589 to 2006-05-09 f2Plan 1884 rows
A449415 DB2PLAN E 51 25.05.2004 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A523593 DB2PLAN E 51 25.02.2004 TABLE_TY 31 to 2005-02-25 f2Plan ---204 ro
A249894 DB2PLAN E 51 28.01.2004 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A589446 DB2PLAN E 51 28.01.2004 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A497088 DB2PLAN E 51 28.01.2004 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A331647 DB2PLAN E 51 28.01.2004 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A166573 DB2PLAN E 51 28.01.2004 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A164392 DB2PLAN E 51 28.01.2004 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A167138 DB2PLAN E 51 24.09.2003 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A424475 DB2PLAN E 51 16.09.2003 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A366335 DB2PLAN E 51 16.09.2003 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A188662 DB2PLAN E 51 11.09.2003 TABLE_TY 276 to 2010-06-22 f2Plan 169 rows
$#out 20120329 09:23:55
RZ1 DbAF 20120329 09:23:56
A223522 DB2PLAN U 64 22.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A581755 DB2PLAN U 64 21.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A730200 DB2PLAN U 64 21.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A540769 DB2PLAN U 64 21.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A174610 DB2PLAN U 64 20.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
A558920 DB2PLAN U 59 20.03.2012 PARENT_P 4 to 2012-03-20 f2Plan 0 rows
CMNBATCH DB2PLAN U 64 19.03.2012 MERGN 1963262 to 2012-03-29 f2Plan ---204 ro
A230582 DB2PLAN U 59 06.03.2012 PARENT_P 89 to 2012-03-16 f2Plan 0 rows
A588168 DB2PLAN U 59 15.02.2012 PARENT_P 2 to 2012-02-15 f2Plan 2 rows
A218042 DB2PLAN U 59 15.02.2012 PARENT_P 2 to 2012-02-15 f2Plan 3 rows
A351153 DB2PLAN U 64 30.01.2012 MERGN 217 to 2012-01-12 f2Plan 0 rows
A754048 DB2PLAN U 64 27.01.2012 MERGN 12 to 2012-02-08 f2Plan ---204 ro
A828386 DB2PLAN U 59 24.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A715414 DB2PLAN E 59 24.01.2012 PARENT_P 5 to 2012-01-24 f2Plan 0 rows
A422686 DB2PLAN U 59 24.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A595055 DB2PLAN E 59 17.01.2012 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A662172 DB2PLAN U 59 12.01.2012 PARENT_P 418 to 2012-01-12 f2Plan ---204 ro
A313703 DB2PLAN U 59 28.12.2011 PARENT_P 7 to 2011-12-29 f2Plan 0 rows
A981516 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A979074 DB2PLAN U 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A961140 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A960926 DB2PLAN E 58 28.12.2011 STMTTOKE 8 to 2011-12-28 f2Plan 0 rows
A955213 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A951242 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A927198 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A919233 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A918249 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan ---204 ro
A915246 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A914227 DB2PLAN U 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A892564 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A850128 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A837210 DB2PLAN E 59 28.12.2011 PARENT_P 35 to 2012-01-18 f2Plan 110 rows
A736627 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A705273 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A666308 DB2PLAN U 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A635743 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A632051 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A629518 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A629484 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A626217 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A621463 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A620076 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A596175 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A589446 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A587951 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A586033 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A577182 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A572942 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A572695 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A570617 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A563742 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A563637 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A559315 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A541931 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A532800 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A532359 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A532022 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A530267 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A524624 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524551 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524500 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524438 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524365 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524314 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A524292 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523539 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523482 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523385 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523318 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A523288 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A522582 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A521072 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A512928 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A512707 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A511115 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A510860 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A510291 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A510178 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A509137 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A508938 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A508742 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A506455 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A506375 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A497088 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A487481 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A485020 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A474375 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A472348 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A472313 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A471902 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A467700 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A465791 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A462253 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A454262 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A424475 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A406205 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A394898 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A390880 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A385879 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A373734 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A370464 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A366335 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A361694 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A359673 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A351230 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A349155 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A347067 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A346474 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A345745 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A344129 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A342480 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A337145 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A331647 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A327913 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A323691 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A317296 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A317210 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A313483 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A313291 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A309200 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A281305 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A276719 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A274961 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A268813 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A267272 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A267256 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A267248 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A266578 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A258214 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A255371 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A254812 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A249894 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A244058 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A242407 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A230698 DB2PLAN E 59 28.12.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A227440 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A223569 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A223348 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A223062 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A222384 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A217534 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A215813 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A197300 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A177397 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A169890 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A167669 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A167452 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A167138 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A166573 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A164392 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A156586 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A155853 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A152110 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan 0 rows
A139274 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A118753 DB2PLAN E 51 28.12.2011 TABLE_TY 0 to 0001-01-01 f2Plan ---204 ro
A116231 DB2PLAN E 58 28.12.2011 STMTTOKE 0 to 0001-01-01 f2Plan 0 rows
A523593 AU03A1A U 59 22.08.2011 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A543397 DA543397 U 59 11.05.2011 PARENT_P 3 to 2011-05-11 f2Plan 1 rows
A677016 DA677016 U 59 03.05.2011 PARENT_P 8 to 2011-05-03 f2Plan 0 rows
A623447 DA623447 E 59 27.01.2011 PARENT_P 5 to 2011-02-02 f2Plan ---204 ro
A700522 DA700522 E 58 04.11.2010 STMTTOKE 3 to 2010-11-04 f2Plan 0 rows
A168658 DA168658 U 59 25.06.2010 PARENT_P 0 to 0001-01-01 f2Plan ---204 ro
A230450 DA230450 E 59 24.03.2010 PARENT_P 319 to 2012-03-17 f2Plan 10 rows
A273818 DA273818 U 59 04.03.2010 PARENT_P 26 to 2010-06-08 f2Plan ---204 ro
A188662 DA188662 U 59 13.01.2010 PARENT_P 19 to 2010-01-13 f2Plan 5 rows
A377027 DA377027 U 59 21.10.2009 PARENT_P 0 to 0001-01-01 f2Plan 0 rows
A484692 DSQDBDEF U 59 06.08.2009 PARENT_P 1073 to 2011-02-17 f2Plan 595 rows
ANLUSER1 IDTANL00 E 59 15.07.2009 PARENT_P 10 to 2011-11-11 f2Plan ---204 ro
A651777 DA651777 E 58 25.03.2009 STMTTOKE 77 to 2011-01-06 f2Plan 0 rows
A426625 DA426625 E 58 26.05.2008 STMTTOKE 449 to 2009-05-26 f2Plan 114 rows
A618725 DA618725 E 58 31.07.2007 STMTTOKE 17780 to 2010-11-29 f2Plan ---204 ro
A533734 DSNDB04 E 58 19.10.2006 STMTTOKE 4 to 2008-02-08 f2Plan ---204 ro
A634011 DSNDB04 E 58 19.10.2006 STMTTOKE 1 to 2006-10-20 f2Plan ---204 ro
A108875 SV02A1A E 58 12.09.2006 STMTTOKE 2 to 2010-02-11 f2Plan 0 rows
A547666 WN01A1A E 51 11.05.2005 TABLE_TY 1 to 2005-12-09 f2Plan 15 rows
A215396 WA01A1A E 46 11.12.2003 BIND_TIM 6 to 2003-12-11 f2Plan 9 rows
A459429 DA459429 E 51 24.04.2003 TABLE_TY 2 to 2003-04-24 f2Plan ---204 ro
A573701 WA01A1A E 46 25.02.2002 BIND_TIM 634 to 2007-09-05 f2Plan 727 rows
A830011 DA830011 E 46 26.09.2000 BIND_TIM 3 to 2000-09-26 f2Plan ---204 ro
A829269 DA829269 E 43 27.08.1997 IBM_SERV 32 to --- f2Plan 55 rows
A449415 DA449415 E 34 09.05.1995 JOIN_PGR 13 to --- f2Plan ---204 ro
A516058 DA516058 E 34 08.03.1995 JOIN_PGR 10 to --- f2Plan ---204 ro
A620181 DA620181 E 30 04.01.1994 COLLID 48 to --- f2Plan ---204 ro
$#out 20120329 09:22:18
RZ1 DbAF 20120329 09:22:18
CMNBATCH DB2PLAN U 64 19.03.2012 MERGN 1963262 to 2012-03-29 f2Plan ---204 ro
S100006 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
S101869 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
S107189 DB2PLAN U 64 19.03.2012 MERGN 13 to 2012-03-08 f2Plan 0 rows
S107887 DB2PLAN U 64 19.03.2012 MERGN 0 to 0001-01-01 f2Plan 0 rows
$#out 20120329 09:20:31
RZ1 DbAF 20120329 09:20:31
CMNBATCH DB2PLAN U 64 MERGN 19.03.20121963262 to 2012-03-29 f2Plan ---204 r
S100006 DB2PLAN U 64 MERGN 19.03.2012 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 64 MERGN 19.03.2012 0 to 0001-01-01 f2Plan 0 rows
S101869 DB2PLAN U 64 MERGN 19.03.2012 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 64 MERGN 19.03.2012 0 to 0001-01-01 f2Plan 0 rows
S107189 DB2PLAN U 64 MERGN 19.03.2012 13 to 2012-03-08 f2Plan 0 rows
S107887 DB2PLAN U 64 MERGN 19.03.2012 0 to 0001-01-01 f2Plan 0 rows
$#out 20120329 09:18:35
RZ1 DbAF 20120329 09:18:35
CMNBATCH DB2PLAN U 19.03.2012 64 MERGN 1963232 to 2012-03-29 f2Plan ---20
S100006 DB2PLAN U 19.03.2012 64 MERGN 0 to 0001-01-01 f2Plan 0 row
S100447 DB2PLAN U 19.03.2012 64 MERGN 0 to 0001-01-01 f2Plan 0 row
S101869 DB2PLAN U 19.03.2012 64 MERGN 0 to 0001-01-01 f2Plan 0 row
S103931 DB2PLAN U 19.03.2012 64 MERGN 0 to 0001-01-01 f2Plan 0 row
S107189 DB2PLAN U 19.03.2012 64 MERGN 13 to 2012-03-08 f2Plan 0 row
S107887 DB2PLAN U 19.03.2012 64 MERGN 0 to 0001-01-01 f2Plan 0 row
$#out 20120329 09:17:29
$#out 20120320 12:09:38
RZ1 DbAF 20120320 12:09:40
DB2OE AOCQTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
DB2OSC AOCQTDB U 64 MERGN 1280 to 2012-03-16 f2Plan ---204 rows
A523593 AU03A1A U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A168658 DA168658 U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A188662 DA188662 U 59 PARENT_PLANN 19 to 2010-01-13 f2Plan 5 rows
A223522 DA223522 E 59 PARENT_PLANN 4 to 2011-09-07 f2Plan ---204 rows
A230450 DA230450 E 59 PARENT_PLANN 319 to 2012-03-17 f2Plan 10 rows
A273818 DA273818 U 59 PARENT_PLANN 26 to 2010-06-08 f2Plan ---204 rows
A377027 DA377027 U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A426625 DA426625 E 58 STMTTOKEN 449 to 2009-05-26 f2Plan 114 rows
A449415 DA449415 E 34 JOIN_PGROUP_ 13 to --- f2Plan ---204 rows
A459429 DA459429 E 51 TABLE_TYPE 2 to 2003-04-24 f2Plan ---204 rows
A516058 DA516058 E 34 JOIN_PGROUP_ 10 to --- f2Plan ---204 rows
A543397 DA543397 U 59 PARENT_PLANN 3 to 2011-05-11 f2Plan 1 rows
A618725 DA618725 E 58 STMTTOKEN 17780 to 2010-11-29 f2Plan ---204 rows
A620181 DA620181 E 30 COLLID 48 to --- f2Plan ---204 rows
A623447 DA623447 E 59 PARENT_PLANN 5 to 2011-02-02 f2Plan ---204 rows
A651777 DA651777 E 58 STMTTOKEN 77 to 2011-01-06 f2Plan 0 rows
A677016 DA677016 U 59 PARENT_PLANN 8 to 2011-05-03 f2Plan 0 rows
A700522 DA700522 E 58 STMTTOKEN 3 to 2010-11-04 f2Plan 0 rows
A829269 DA829269 E 43 IBM_SERVICE_ 32 to --- f2Plan 55 rows
A830011 DA830011 E 46 BIND_TIME 3 to 2000-09-26 f2Plan ---204 rows
A118753 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A139274 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A156586 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A164392 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A166573 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167138 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167452 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167669 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A169890 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A217534 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A249894 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A331647 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A344129 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A345745 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A361694 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A366335 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A370464 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A424475 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A471902 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A487481 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A497088 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A530267 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A532800 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A563637 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A563742 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A570617 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A586033 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A589446 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A961140 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F192213 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F222112 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F240889 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F260200 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F306871 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F526782 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F535609 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F540270 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F546562 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F551132 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F600435 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F604252 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F940771 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A152110 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A174610 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A177397 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A222384 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A227440 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A255371 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A258214 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A281305 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A313483 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A317210 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A337145 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A346474 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A359673 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A385879 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A462253 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A465791 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A474375 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A506455 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A508938 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A522582 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A572695 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A572942 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A577182 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A596175 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A620076 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A629484 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A632051 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A915246 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A951242 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A955213 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A981516 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
B223522 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F151800 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F227955 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F247743 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F293923 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F377760 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F524941 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F542850 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F558781 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F572296 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F607057 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F616625 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F629042 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F985779 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
X979074 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A918249 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan ---204 rows
A116231 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A155853 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A197300 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A215813 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223062 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223348 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223569 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A244058 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A266578 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A267256 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A268813 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A276719 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A317296 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A327913 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A347067 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A390880 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A394898 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A467700 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A472313 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A532022 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A541931 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A587951 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A621463 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A629518 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A892564 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A919233 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F100150 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F107992 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F256274 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F262061 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F273764 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F278290 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F326930 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F403358 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F473828 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F531557 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F540769 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F547534 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F578255 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F578271 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F587242 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F614967 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F616617 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F631527 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F633341 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F731398 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F873288 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F996967 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A960926 DB2PLAN E 58 STMTTOKEN 8 to 2011-12-28 f2Plan 0 rows
A254812 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A267272 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A373734 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A559315 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A927198 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
EXTRSQL DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
F718952 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A230698 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A242407 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A267248 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A274961 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A309200 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A313291 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A323691 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A342480 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A349155 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A351230 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A406205 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A454262 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A472348 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A485020 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A506375 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A508742 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A509137 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510178 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510291 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510860 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A511115 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A512707 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A512928 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A521072 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523288 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523318 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523385 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523482 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523539 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524292 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524314 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524365 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524438 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524500 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524551 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524624 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A532359 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A595055 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A626217 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A635743 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A705273 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A736627 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A850128 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F248700 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F263146 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F305976 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F325400 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F383764 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F492730I DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F496361 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F540657 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F597926 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F602687 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F701065 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F975595 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A715414 DB2PLAN E 59 PARENT_PLANN 5 to 2012-01-24 f2Plan 0 rows
A837210 DB2PLAN E 59 PARENT_PLANN 35 to 2012-01-18 f2Plan 110 rows
A914227 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A979074 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A422686 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A666308 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A828386 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
DB2ADMIN DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F570617 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A588168 DB2PLAN U 59 PARENT_PLANN 2 to 2012-02-15 f2Plan 2 rows
A218042 DB2PLAN U 59 PARENT_PLANN 2 to 2012-02-15 f2Plan 3 rows
A313703 DB2PLAN U 59 PARENT_PLANN 7 to 2011-12-29 f2Plan 0 rows
F475812 DB2PLAN U 59 PARENT_PLANN 10 to 2012-03-15 f2Plan 0 rows
A230582 DB2PLAN U 59 PARENT_PLANN 89 to 2012-03-16 f2Plan 0 rows
A662172 DB2PLAN U 59 PARENT_PLANN 418 to 2012-01-12 f2Plan ---204 rows
A540769 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S100006 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S101869 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
A754048 DB2PLAN U 64 MERGN 12 to 2012-02-08 f2Plan ---204 rows
S107189 DB2PLAN U 64 MERGN 13 to 2012-03-08 f2Plan 0 rows
A351153 DB2PLAN U 64 MERGN 217 to 2012-01-12 f2Plan 0 rows
CMNBATCH DB2PLAN U 64 MERGN 1904333 to 2012-03-20 f2Plan ---204 rows
F383353 DF383353 E 58 STMTTOKEN 5 to 2012-03-07 f2Plan ---204 rows
F464418 DF464418 U 59 PARENT_PLANN 3 to 2011-02-03 f2Plan 3 rows
GDB0135 DGDB0135 E 46 BIND_TIME 5 to 2006-02-17 f2Plan ---204 rows
GDB0178 DGDB0178 E 59 PARENT_PLANN 3 to 2011-07-12 f2Plan ---204 rows
GDB0275 DGDB0275 E 49 PRIMARY_ACCE 8 to 2007-10-09 f2Plan ---204 rows
GOWM200 DGOWM200 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan ---204 rows
F890588 DHPSD53 E 46 BIND_TIME 4 to 2001-07-19 f2Plan 5 rows
A634011 DSNDB04 E 58 STMTTOKEN 1 to 2006-10-20 f2Plan ---204 rows
A533734 DSNDB04 E 58 STMTTOKEN 4 to 2008-02-08 f2Plan ---204 rows
A484692 DSQDBDEF U 59 PARENT_PLANN 1073 to 2011-02-17 f2Plan 595 rows
OPTHINT DS100447 E 51 TABLE_TYPE 28 to 2004-12-13 f2Plan ---204 rows
T022527 DT022527 E 46 BIND_TIME 24 to 2000-09-20 f2Plan 1 rows
W015660 DW015660 E 46 BIND_TIME ---904 to sqlCode f2Plan ---904 rows
X002127 DX002127 E 46 BIND_TIME 3 to 2003-06-13 f2Plan 2 rows
X002151 DX002151 E 46 BIND_TIME 5 to 2003-06-13 f2Plan 3 rows
ANLUSER1 IDTANL00 E 59 PARENT_PLANN 10 to 2011-11-11 f2Plan ---204 rows
A108875 SV02A1A E 58 STMTTOKEN 2 to 2010-02-11 f2Plan 0 rows
F288874 VV29A1X E 59 PARENT_PLANN 120 to 2010-12-09 f2Plan ---204 rows
A215396 WA01A1A E 46 BIND_TIME 6 to 2003-12-11 f2Plan 9 rows
A573701 WA01A1A E 46 BIND_TIME 634 to 2007-09-05 f2Plan 727 rows
A547666 WN01A1A E 51 TABLE_TYPE 1 to 2005-12-09 f2Plan 15 rows
$#out 20120320 12:09:18
RZ1 Dboc 20120320 12:09:19
A234579 DA234579 E 58 STMTTOKEN 2 to 2006-04-28 f2Plan ---204 rows
A273818 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A420093 DA420093 U 59 PARENT_PLANN 64 to 2011-05-11 f2Plan 45 rows
A525433 DB2PLAN E 51 TABLE_TYPE 10 to 2010-12-06 f2Plan 0 rows
A540769 DB2PLAN E 58 STMTTOKEN 4 to 2010-12-13 f2Plan 0 rows
A604511 DCMN E 28 MIXOPSEQ 55 to --- f2Plan ---204 rows
A914227 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A979074 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
ANLUSER1 IDTANL00 E 59 PARENT_PLANN 2 to 2010-06-11 f2Plan ---204 rows
B167274 DS100447 E 58 STMTTOKEN 39 to 2006-06-13 f2Plan ---204 rows
CMNBATCH DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
DB2OSC DB2OSC U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
F325756 DCMN E 58 STMTTOKEN 1 to 2008-02-18 f2Plan 1 rows
F547240 DCMNT E 58 STMTTOKEN 80 to 2007-06-18 f2Plan ---204 rows
F557963 DCMN E 58 STMTTOKEN 135 to 2008-05-21 f2Plan 107 rows
F602687 DSN00060 U 59 PARENT_PLANN 1037 to 2009-07-15 f2Plan 2015 rows
F875019 DSN00551 U 59 PARENT_PLANN 72 to 2011-08-09 f2Plan ---204 rows
OPTHINT DS100447 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
PROTOTYP DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 78 to 2012-03-16 f2Plan 0 rows
SSXX28Q0 DCMN E 28 MIXOPSEQ 0 to --- f2Plan ---204 rows
SSXX28QZ DCMNZ E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120319 20:01:33
RZ1 Dboc 20120319 20:01:33
CMNBATCH DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
S100447 DB2PLAN U 59 PARENT_PLANN 78 to 2012-03-16 f2Plan 0 rows
SSXX28Q0 DCMN E 28 MIXOPSEQ 0 to --- f2Plan ---204 rows
SSXX28QZ DCMNZ E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120319 19:58:52
RZ1 Dbaf 20120319 19:58:52
CMNBATCH DB2PLAN U 64 MERGN 1902433 to 2012-03-19 f2Plan ---204 rows
S100006 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S101869 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S107189 DB2PLAN U 64 MERGN 13 to 2012-03-08 f2Plan 0 rows
S107887 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
$#out 20120319 17:56:53
RZ1 Dbaf 20120319 17:56:53
CMNBATCH DB2PLAN U 64 MERGN 1902231 to 2012-03-19 f2Plan ---204 rows
S100006 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 64 MERGN 0 to 0001-01-01 f2Plan 0 rows
S101869 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S107189 DB2PLAN U 59 PARENT_PLANN 13 to 2012-03-08 f2Plan 0 rows
S107887 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
$#out 20120319 16:27:56
RZ1 Dbaf 20120319 16:27:56
CMNBATCH DB2PLAN U 59 PARENT_PLANN1901779 to 2012-03-19 f2Plan ---204 rows
S100006 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 2366 to 2012-03-17 f2Plan 0 rows
S101869 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S107189 DB2PLAN U 59 PARENT_PLANN 13 to 2012-03-08 f2Plan 0 rows
S107887 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
$#out 20120319 16:27:34
RZ1 Dbba 20120319 16:27:34
CMNBATCH DB2PLAN U 64 MERGN 409998 to 2012-03-19 f2Plan 0 rows
S100447 DB2PLAN U 64 MERGN 28 to 2012-03-17 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120319 16:16:00
RZ1 Dbba 20120319 16:16:00
CMNBATCH DB2PLAN U 64 MERGN 409988 to 2012-03-19 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 28 to 2012-03-17 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 22:14:30
RZ1 Dboc 20120210 22:14:30
CMNBATCH DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
S100447 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
SSXX28Q0 DCMN E 28 MIXOPSEQ 0 to --- f2Plan ---204 rows
SSXX28QZ DCMNZ E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 22:04:38
RZ1 Dboc 20120210 22:04:38
CMNBATCH DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
S100006 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 28 to 2010-06-11 f2Plan 1 rows
SSXX28Q0 DCMN E 28 MIXOPSEQ 0 to --- f2Plan ---204 rows
SSXX28QZ DCMNZ E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 22:04:24
RZ1 Dvtb 20120210 22:04:24
CMNBATCH DB2PLAN U 59 PARENT_PLANN 957328 to 2012-02-09 f2Plan ---204 rows
S100447 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 22:01:57
RZ1 Dvtb 20120210 22:01:58
CMNBATCH DB2PLAN U 59 PARENT_PLANN 957328 to 2012-02-09 f2Plan ---204 rows
S100006 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN E 58 STMTTOKEN 44 to 2012-01-23 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 22:01:20
RZ1 DBBA 20120210 22:01:20
CMNBATCH DB2PLAN U 59 PARENT_PLANN 178872 to 2012-02-10 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 21:54:53
RZ1 DBBA 20120210 21:54:53
CMNBATCH DB2PLAN U 59 PARENT_PLANN 178872 to 2012-02-10 f2Plan 0 rows
S100006 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN E 58 STMTTOKEN 82 to 2012-01-18 f2Plan 0 rows
S101869 DS100447 E 43 IBM_SERVICE_ 0 to --- f2Plan ---204 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 21:54:31
RZ1 DBAF 20120210 21:54:31
CMNBATCH DB2PLAN U 59 PARENT_PLANN 658685 to 2012-02-10 f2Plan ---904 rows
S100006 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 882 to 2012-01-18 f2Plan 0 rows
S101869 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
$#out 20120210 21:53:53
RZ1 DBTF 20120210 21:53:53
CMNBATCH DB2PLAN U 59 PARENT_PLANN7858063 to 2012-02-10 f2Plan ---904 rows
S100447 DB2PLAN U 59 PARENT_PLANN 21537 to 2012-01-25 f2Plan 67 rows
S101869 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 21:52:39
RZ1 DBBA 20120210 21:52:39
S100006 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN E 58 STMTTOKEN 82 to 2012-01-18 f2Plan 0 rows
S101869 DS100447 E 43 IBM_SERVICE_ 0 to --- f2Plan ---204 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 21:52:15
RZ1 DBTF 20120210 21:52:15
S100447 DB2PLAN U 59 PARENT_PLANN 21537 to 2012-01-25 f2Plan 67 rows
S101869 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 21:43:34
RZ1 DBTF 20120210 21:43:34
S100006 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 21537 to 2012-01-25 f2Plan 67 rows
S101869 DB2PLAN E 58 STMTTOKEN 187687 to 2012-02-02 f2Plan 0 rows
S103931 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN E 59 PARENT_PLANN 220 to 2011-09-22 f2Plan 0 rows
SYSIBM DSNOPTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
$#out 20120210 21:42:51
RZ1 DBTF 20120210 21:42:51
CMNBATCH DB2PLAN U 59 PARENT_PLANN7858063 to 2012-02-10 f2Plan ---904 rows
$#out 20120210 21:42:33
RZ1 DBAF 20120210 21:42:33
CMNBATCH DB2PLAN U 59 PARENT_PLANN 658685 to 2012-02-10 f2Plan ---904 rows
$#out 20120210 21:42:01
RZ1 DBAF 20120210 21:42:02
S100006 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 882 to 2012-01-18 f2Plan 0 rows
S101869 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
$#out 20120208 21:04:42
RZ1 DBAF 20120208 21:04:42
DB2OSC AOCQTDB U 64 MERGN 2 to 2012-01-30 f2Plan ---204 rows
DB2OE AOCQTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
A523593 AU03A1A U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A168658 DA168658 U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A188662 DA188662 U 59 PARENT_PLANN 19 to 2010-01-13 f2Plan 5 rows
A223522 DA223522 E 59 PARENT_PLANN 4 to 2011-09-07 f2Plan ---204 rows
A230450 DA230450 E 59 PARENT_PLANN 226 to 2012-01-13 f2Plan 10 rows
A273818 DA273818 U 59 PARENT_PLANN 26 to 2010-06-08 f2Plan ---204 rows
A377027 DA377027 U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A426625 DA426625 E 58 STMTTOKEN 449 to 2009-05-26 f2Plan 114 rows
A449415 DA449415 E 34 JOIN_PGROUP_ 13 to --- f2Plan ---204 rows
A459429 DA459429 E 51 TABLE_TYPE 2 to 2003-04-24 f2Plan ---204 rows
A516058 DA516058 E 34 JOIN_PGROUP_ 10 to --- f2Plan ---204 rows
A543397 DA543397 U 59 PARENT_PLANN 3 to 2011-05-11 f2Plan 1 rows
A618725 DA618725 E 58 STMTTOKEN 17780 to 2010-11-29 f2Plan ---204 rows
A620181 DA620181 E 30 COLLID 48 to --- f2Plan ---204 rows
A623447 DA623447 E 59 PARENT_PLANN 5 to 2011-02-02 f2Plan ---204 rows
A651777 DA651777 E 58 STMTTOKEN 77 to 2011-01-06 f2Plan 0 rows
A677016 DA677016 U 59 PARENT_PLANN 8 to 2011-05-03 f2Plan 0 rows
A700522 DA700522 E 58 STMTTOKEN 3 to 2010-11-04 f2Plan 0 rows
A829269 DA829269 E 43 IBM_SERVICE_ 32 to --- f2Plan 55 rows
A830011 DA830011 E 46 BIND_TIME 3 to 2000-09-26 f2Plan ---204 rows
A116231 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A118753 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A139274 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A152110 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A155853 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A156586 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A164392 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A166573 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167138 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167452 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167669 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A169890 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A174610 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A177397 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A197300 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A215813 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A217534 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A218042 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A222384 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A223062 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223348 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223569 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A227440 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A230582 DB2PLAN E 59 PARENT_PLANN 10 to 2012-01-10 f2Plan 0 rows
A230698 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A242407 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A244058 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A249894 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A254812 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A255371 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A258214 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A266578 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A267248 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A267256 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A267272 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A268813 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A274961 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A276719 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A281305 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A309200 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A313291 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A313483 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A313703 DB2PLAN U 59 PARENT_PLANN 7 to 2011-12-29 f2Plan 0 rows
A317210 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A317296 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A323691 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A327913 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A331647 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A337145 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A342480 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A344129 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A345745 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A346474 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A347067 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A349155 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A351230 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A359673 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A361694 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A366335 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A370464 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A373734 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A385879 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A390880 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A394898 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A406205 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A422686 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A424475 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A454262 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A462253 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A465791 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A467700 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A471902 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A472313 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A472348 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A474375 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A485020 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A487481 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A497088 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A506375 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A506455 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A508742 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A508938 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A509137 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510178 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510291 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510860 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A511115 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A512707 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A512928 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A521072 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A522582 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A523288 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523318 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523385 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523482 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523539 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524292 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524314 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524365 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524438 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524500 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524551 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524624 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A530267 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A532022 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A532359 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A532800 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A541931 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A559315 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A563637 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A563742 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A570617 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A572695 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A572942 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A577182 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A586033 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A587951 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A589446 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A595055 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A596175 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A620076 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A621463 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A626217 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A629484 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A629518 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A632051 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A635743 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A666308 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A705273 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A715414 DB2PLAN E 59 PARENT_PLANN 5 to 2012-01-24 f2Plan 0 rows
A736627 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A828386 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A837210 DB2PLAN E 59 PARENT_PLANN 35 to 2012-01-18 f2Plan 110 rows
A850128 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A892564 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A914227 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A915246 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A918249 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan ---204 rows
A919233 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A927198 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A951242 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A955213 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A960926 DB2PLAN E 58 STMTTOKEN 8 to 2011-12-28 f2Plan 0 rows
A961140 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A979074 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A981516 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A351153 DB2PLAN U 64 MERGN 217 to 2012-01-12 f2Plan 0 rows
B223522 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
CMNBATCH DB2PLAN U 59 PARENT_PLANN 583965 to 2012-02-08 f2Plan 0 rows
A662172 DB2PLAN U 59 PARENT_PLANN 418 to 2012-01-12 f2Plan ---204 rows
A754048 DB2PLAN U 64 MERGN 12 to 2012-02-08 f2Plan ---204 rows
A540769 DB2PLAN U 64 MERGN 5 to 2012-02-07 f2Plan ---204 rows
EXTRSQL DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
F100150 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F107992 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F151800 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F192213 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F222112 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F227955 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F240889 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F247743 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F248700 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F256274 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F260200 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F262061 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F263146 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F273764 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F278290 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F293923 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F305976 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F306871 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F325400 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F326930 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F377760 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F383764 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F403358 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F473828 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F475812 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F492730I DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F496361 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F524941 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F526782 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F531557 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F535609 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F540270 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F540657 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F540769 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F542850 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F546562 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F547534 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F551132 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F558781 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F570617 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F572296 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F578255 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F578271 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F587242 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F597926 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F600435 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F602687 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F604252 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F607057 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F614967 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F616617 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F616625 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F629042 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F631527 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F633341 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F701065 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F731398 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F873288 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F940771 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F975595 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F985779 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F996967 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F718952 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
S100006 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 882 to 2012-01-18 f2Plan 0 rows
S101869 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
X979074 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F383353 DF383353 E 58 STMTTOKEN 1 to 2012-02-02 f2Plan ---204 rows
F464418 DF464418 U 59 PARENT_PLANN 3 to 2011-02-03 f2Plan 3 rows
GDB0135 DGDB0135 E 46 BIND_TIME 5 to 2006-02-17 f2Plan ---204 rows
GDB0178 DGDB0178 E 59 PARENT_PLANN 3 to 2011-07-12 f2Plan ---204 rows
GDB0275 DGDB0275 E 49 PRIMARY_ACCE 8 to 2007-10-09 f2Plan ---204 rows
GOWM200 DGOWM200 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan ---204 rows
F890588 DHPSD53 E 46 BIND_TIME 4 to 2001-07-19 f2Plan 5 rows
OPTHINT DS100447 E 51 TABLE_TYPE 28 to 2004-12-13 f2Plan ---204 rows
A634011 DSNDB04 E 58 STMTTOKEN 1 to 2006-10-20 f2Plan ---204 rows
A533734 DSNDB04 E 58 STMTTOKEN 4 to 2008-02-08 f2Plan ---204 rows
A588168 DSNDB04 E 58 STMTTOKEN 2 to 2006-10-19 f2Plan 0 rows
A484692 DSQDBDEF U 59 PARENT_PLANN 1073 to 2011-02-17 f2Plan 595 rows
T022527 DT022527 E 46 BIND_TIME 24 to 2000-09-20 f2Plan 1 rows
W015660 DW015660 E 46 BIND_TIME ---904 to sqlCode f2Plan ---904 rows
X002127 DX002127 E 46 BIND_TIME 3 to 2003-06-13 f2Plan 2 rows
X002151 DX002151 E 46 BIND_TIME 5 to 2003-06-13 f2Plan 3 rows
ANLUSER1 IDTANL00 E 59 PARENT_PLANN 10 to 2011-11-11 f2Plan ---204 rows
A108875 SV02A1A E 58 STMTTOKEN 2 to 2010-02-11 f2Plan 0 rows
F288874 VV29A1X E 59 PARENT_PLANN 120 to 2010-12-09 f2Plan ---204 rows
A215396 WA01A1A E 46 BIND_TIME 6 to 2003-12-11 f2Plan 9 rows
A573701 WA01A1A E 46 BIND_TIME 634 to 2007-09-05 f2Plan 727 rows
A547666 WN01A1A E 51 TABLE_TYPE 1 to 2005-12-09 f2Plan 15 rows
$#out 20120208 21:02:49
RZ1 DBAF 20120208 21:02:50
DB2OSC AOCQTDB U 64 MERGN 2 to 2012-01-30 f2Plan ---204 rows
DB2OE AOCQTDB U 64 MERGN 0 to 0001-01-01 f2Plan ---204 rows
A523593 AU03A1A U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A168658 DA168658 U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A188662 DA188662 U 59 PARENT_PLANN 19 to 2010-01-13 f2Plan 5 rows
A223522 DA223522 E 59 PARENT_PLANN 4 to 2011-09-07 f2Plan ---204 rows
A230450 DA230450 E 59 PARENT_PLANN 226 to 2012-01-13 f2Plan 10 rows
A273818 DA273818 U 59 PARENT_PLANN 26 to 2010-06-08 f2Plan ---204 rows
A377027 DA377027 U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A426625 DA426625 E 58 STMTTOKEN 449 to 2009-05-26 f2Plan 114 rows
A449415 DA449415 E 34 JOIN_PGROUP_ 13 to --- f2Plan ---204 rows
A459429 DA459429 E 51 TABLE_TYPE 2 to 2003-04-24 f2Plan ---204 rows
A516058 DA516058 E 34 JOIN_PGROUP_ 10 to --- f2Plan ---204 rows
A543397 DA543397 U 59 PARENT_PLANN 3 to 2011-05-11 f2Plan 1 rows
A618725 DA618725 E 58 STMTTOKEN 17780 to 2010-11-29 f2Plan ---204 rows
A620181 DA620181 E 30 COLLID 48 to --- f2Plan ---204 rows
A623447 DA623447 E 59 PARENT_PLANN 5 to 2011-02-02 f2Plan ---204 rows
A651777 DA651777 E 58 STMTTOKEN 77 to 2011-01-06 f2Plan 0 rows
A677016 DA677016 U 59 PARENT_PLANN 8 to 2011-05-03 f2Plan 0 rows
A700522 DA700522 E 58 STMTTOKEN 3 to 2010-11-04 f2Plan 0 rows
A829269 DA829269 E 43 IBM_SERVICE_ 32 to --- f2Plan 55 rows
A830011 DA830011 E 46 BIND_TIME 3 to 2000-09-26 f2Plan ---204 rows
A116231 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A118753 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A139274 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A152110 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A155853 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A156586 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A164392 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A166573 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167138 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167452 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A167669 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A169890 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A174610 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A177397 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A197300 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A215813 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A217534 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A218042 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A222384 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A223062 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223348 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223569 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A227440 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A230582 DB2PLAN E 59 PARENT_PLANN 10 to 2012-01-10 f2Plan 0 rows
A230698 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A242407 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A244058 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A249894 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A254812 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A255371 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A258214 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A266578 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A267248 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A267256 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A267272 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A268813 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A274961 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A276719 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A281305 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A309200 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A313291 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A313483 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A313703 DB2PLAN U 59 PARENT_PLANN 7 to 2011-12-29 f2Plan 0 rows
A317210 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A317296 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A323691 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A327913 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A331647 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A337145 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A342480 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A344129 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A345745 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A346474 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A347067 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A349155 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A351230 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A359673 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A361694 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A366335 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A370464 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A373734 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A385879 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A390880 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A394898 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A406205 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A422686 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A424475 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A454262 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A462253 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A465791 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A467700 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A471902 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A472313 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A472348 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A474375 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A485020 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A487481 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A497088 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A506375 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A506455 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A508742 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A508938 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A509137 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510178 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510291 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A510860 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A511115 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A512707 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A512928 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A521072 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A522582 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A523288 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523318 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523385 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523482 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A523539 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524292 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524314 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524365 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524438 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524500 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524551 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A524624 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A530267 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A532022 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A532359 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A532800 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A541931 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A559315 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A563637 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A563742 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A570617 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A572695 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A572942 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A577182 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A586033 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A587951 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A589446 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A595055 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A596175 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A620076 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A621463 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A626217 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A629484 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A629518 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A632051 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A635743 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A666308 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A705273 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A715414 DB2PLAN E 59 PARENT_PLANN 5 to 2012-01-24 f2Plan 0 rows
A736627 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A828386 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A837210 DB2PLAN E 59 PARENT_PLANN 35 to 2012-01-18 f2Plan 110 rows
A850128 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
A892564 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A914227 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A915246 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A918249 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan ---204 rows
A919233 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A927198 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A951242 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A955213 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A960926 DB2PLAN E 58 STMTTOKEN 8 to 2011-12-28 f2Plan 0 rows
A961140 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
A979074 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
A981516 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A351153 DB2PLAN U 64 MERGN 217 to 2012-01-12 f2Plan 0 rows
B223522 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
CMNBATCH DB2PLAN U 59 PARENT_PLANN 583965 to 2012-02-08 f2Plan 0 rows
A662172 DB2PLAN U 59 PARENT_PLANN 418 to 2012-01-12 f2Plan ---204 rows
A754048 DB2PLAN U 64 MERGN 12 to 2012-02-08 f2Plan ---204 rows
A540769 DB2PLAN U 64 MERGN 5 to 2012-02-07 f2Plan ---204 rows
EXTRSQL DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
F100150 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F107992 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F151800 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F192213 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F222112 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F227955 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F240889 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F247743 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F248700 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F256274 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F260200 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F262061 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F263146 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F273764 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F278290 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F293923 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F305976 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F306871 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F325400 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F326930 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F377760 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F383764 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F403358 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F473828 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F475812 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F492730I DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F496361 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F524941 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F526782 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F531557 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F535609 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F540270 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F540657 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F540769 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F542850 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F546562 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F547534 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F551132 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F558781 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F570617 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F572296 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F578255 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F578271 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F587242 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F597926 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F600435 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F602687 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F604252 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F607057 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F614967 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F616617 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F616625 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F629042 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F631527 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F633341 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F701065 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F731398 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F873288 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F940771 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan ---204 rows
F975595 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
F985779 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F996967 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F718952 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan ---204 rows
S100006 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 882 to 2012-01-18 f2Plan 0 rows
S101869 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN U 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
X979074 DB2PLAN E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F383353 DF383353 E 58 STMTTOKEN 1 to 2012-02-02 f2Plan ---204 rows
F464418 DF464418 U 59 PARENT_PLANN 3 to 2011-02-03 f2Plan 3 rows
GDB0135 DGDB0135 E 46 BIND_TIME 5 to 2006-02-17 f2Plan ---204 rows
GDB0178 DGDB0178 E 59 PARENT_PLANN 3 to 2011-07-12 f2Plan ---204 rows
GDB0275 DGDB0275 E 49 PRIMARY_ACCE 8 to 2007-10-09 f2Plan ---204 rows
GOWM200 DGOWM200 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan ---204 rows
F890588 DHPSD53 E 46 BIND_TIME 4 to 2001-07-19 f2Plan 5 rows
OPTHINT DS100447 E 51 TABLE_TYPE 28 to 2004-12-13 f2Plan ---204 rows
A634011 DSNDB04 E 58 STMTTOKEN 1 to 2006-10-20 f2Plan ---204 rows
A533734 DSNDB04 E 58 STMTTOKEN 4 to 2008-02-08 f2Plan ---204 rows
A588168 DSNDB04 E 58 STMTTOKEN 2 to 2006-10-19 f2Plan 0 rows
A484692 DSQDBDEF U 59 PARENT_PLANN 1073 to 2011-02-17 f2Plan 595 rows
T022527 DT022527 E 46 BIND_TIME 24 to 2000-09-20 f2Plan 1 rows
W015660 DW015660 E 46 BIND_TIME ---904 to sqlCode f2Plan ---904 rows
X002127 DX002127 E 46 BIND_TIME 3 to 2003-06-13 f2Plan 2 rows
X002151 DX002151 E 46 BIND_TIME 5 to 2003-06-13 f2Plan 3 rows
ANLUSER1 IDTANL00 E 59 PARENT_PLANN 10 to 2011-11-11 f2Plan ---204 rows
A108875 SV02A1A E 58 STMTTOKEN 2 to 2010-02-11 f2Plan 0 rows
F288874 VV29A1X E 59 PARENT_PLANN 120 to 2010-12-09 f2Plan ---204 rows
A215396 WA01A1A E 46 BIND_TIME 6 to 2003-12-11 f2Plan 9 rows
A573701 WA01A1A E 46 BIND_TIME 634 to 2007-09-05 f2Plan 727 rows
A547666 WN01A1A E 51 TABLE_TYPE 1 to 2005-12-09 f2Plan 15 rows
$#out 20120208 21:02:08
RZ1 DBAF 20120208 21:02:09
W015660 DW015660 E 46 BIND_TIME ---904 to sqlCode f2Plan ---904 rows
$#out 20120208 21:01:30
RZ1 DBAF 20120208 21:01:30
*** run error ***
SQLCODE = -904: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90081, TYPE OF RESOURCE 00000100,
AND RESOURCE NAME DW015660
stmt = execSql prepare s2 from :src
with from :src = select count(*), value(max(bind_time), '0001-01-01-00.00.00') f
$#out 20120208 20:55:39
RZ1 DBAF 20120208 20:55:39
*** run error ***
SQLCODE = -904: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90081, TYPE OF RESOURCE 00000100,
AND RESOURCE NAME DW015660
stmt = execSql prepare s2 from :src
with from :src = select count(*), value(max(bind_time), '0001-01-01-00.00.00') f
$#out 20120208 20:48:24
RZ1 DBAF 20120208 20:48:24
S100006 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANN 882 to 2012-01-18 f2Plan 0 rows
S101869 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN E 59 PARENT_PLANN 0 to 0001-01-01 f2Plan 0 rows
$#out 20120208 20:47:55
RZ1 DBAF 20120208 20:47:55
S100006 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 DB2PLAN U 59 PARENT_PLANNO 882 to 2012-01-18 f2Plan 0 rows
S101869 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S103931 DB2PLAN E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S107887 DB2PLAN E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
$#out 20120208 20:43:48
RZ1 DBAF 20120208 20:43:48
S100006 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 U 59 PARENT_PLANNO 882 to 2012-01-18 f2Plan 0 rows
S101869 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S103931 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S107887 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
$#out 20120208 20:40:04
RZ1 DBAF 20120208 20:40:05
DB2OSC U 64 MERGN 2 to 2012-01-30 f2Plan --- rows
DB2OE U 64 MERGN 0 to 0001-01-01 f2Plan --- rows
A523593 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A168658 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A188662 U 59 PARENT_PLANNO 19 to 2010-01-13 f2Plan 5 rows
A223522 E 59 PARENT_PLANNO 4 to 2011-09-07 f2Plan --- rows
A230450 E 59 PARENT_PLANNO 226 to 2012-01-13 f2Plan 10 rows
A273818 U 59 PARENT_PLANNO 26 to 2010-06-08 f2Plan --- rows
A377027 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A426625 E 58 STMTTOKEN 449 to 2009-05-26 f2Plan 114 rows
A449415 E 34 JOIN_PGROUP_ID 13 to --- f2Plan --- rows
A459429 E 51 TABLE_TYPE 2 to 2003-04-24 f2Plan --- rows
A516058 E 34 JOIN_PGROUP_ID 10 to --- f2Plan --- rows
A543397 U 59 PARENT_PLANNO 3 to 2011-05-11 f2Plan 1 rows
A618725 E 58 STMTTOKEN 17780 to 2010-11-29 f2Plan --- rows
A620181 E 30 COLLID 48 to --- f2Plan --- rows
A623447 E 59 PARENT_PLANNO 5 to 2011-02-02 f2Plan --- rows
A651777 E 58 STMTTOKEN 77 to 2011-01-06 f2Plan 0 rows
A677016 U 59 PARENT_PLANNO 8 to 2011-05-03 f2Plan 0 rows
A700522 E 58 STMTTOKEN 3 to 2010-11-04 f2Plan 0 rows
A829269 E 43 IBM_SERVICE_DATA 32 to --- f2Plan 55 rows
A830011 E 46 BIND_TIME 3 to 2000-09-26 f2Plan --- rows
A116231 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A118753 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A139274 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A152110 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A155853 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A156586 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A164392 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A166573 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A167138 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A167452 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A167669 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A169890 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A174610 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A177397 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A197300 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A215813 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A217534 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A218042 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A222384 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A223062 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223348 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A223569 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A227440 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A230582 E 59 PARENT_PLANNO 10 to 2012-01-10 f2Plan 0 rows
A230698 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A242407 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A244058 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A249894 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A254812 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A255371 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A258214 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A266578 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A267248 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A267256 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A267272 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A268813 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A274961 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A276719 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A281305 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A309200 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A313291 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A313483 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A313703 U 59 PARENT_PLANNO 7 to 2011-12-29 f2Plan 0 rows
A317210 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A317296 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A323691 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A327913 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A331647 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A337145 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A342480 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A344129 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A345745 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A346474 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A347067 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A349155 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A351230 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A359673 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A361694 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A366335 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A370464 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A373734 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A385879 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A390880 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A394898 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A406205 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A422686 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A424475 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A454262 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A462253 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A465791 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A467700 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A471902 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A472313 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A472348 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A474375 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A485020 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A487481 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A497088 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A506375 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A506455 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A508742 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A508938 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A509137 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A510178 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A510291 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A510860 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A511115 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A512707 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A512928 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A521072 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A522582 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A523288 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A523318 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A523385 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A523482 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A523539 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A524292 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A524314 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A524365 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A524438 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A524500 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A524551 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A524624 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A530267 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A532022 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A532359 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A532800 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A541931 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A559315 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A563637 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A563742 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A570617 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A572695 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A572942 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A577182 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A586033 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A587951 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A589446 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A595055 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A596175 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A620076 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A621463 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A626217 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A629484 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A629518 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A632051 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A635743 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A666308 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A705273 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A715414 E 59 PARENT_PLANNO 5 to 2012-01-24 f2Plan 0 rows
A736627 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A828386 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A837210 E 59 PARENT_PLANNO 35 to 2012-01-18 f2Plan 110 rows
A850128 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A892564 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A914227 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A915246 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A918249 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan --- rows
A919233 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
A927198 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A951242 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A955213 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A960926 E 58 STMTTOKEN 8 to 2011-12-28 f2Plan 0 rows
A961140 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
A979074 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A981516 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
A351153 U 64 MERGN 217 to 2012-01-12 f2Plan 0 rows
B223522 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
CMNBATCH U 59 PARENT_PLANNO 583965 to 2012-02-08 f2Plan 0 rows
A662172 U 59 PARENT_PLANNO 418 to 2012-01-12 f2Plan --- rows
A754048 U 64 MERGN 12 to 2012-02-08 f2Plan --- rows
A540769 U 64 MERGN 5 to 2012-02-07 f2Plan --- rows
EXTRSQL E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
F100150 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F107992 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F151800 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F192213 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F222112 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F227955 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F240889 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F247743 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F248700 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F256274 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F260200 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F262061 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F263146 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F273764 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F278290 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F293923 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F305976 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F306871 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F325400 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F326930 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F377760 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F383764 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F403358 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F473828 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F475812 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F492730I E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F496361 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F524941 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F526782 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F531557 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F535609 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F540270 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F540657 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F540769 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F542850 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F546562 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F547534 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F551132 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F558781 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F570617 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F572296 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F578255 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F578271 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F587242 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F597926 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F600435 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F602687 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F604252 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F607057 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F614967 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F616617 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F616625 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F629042 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F631527 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F633341 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F701065 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F731398 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F873288 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F940771 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan --- rows
F975595 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
F985779 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F996967 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
F718952 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
S100006 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 U 59 PARENT_PLANNO 882 to 2012-01-18 f2Plan 0 rows
S101869 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S103931 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S107887 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
X979074 E 51 TABLE_TYPE 0 to 0001-01-01 f2Plan 0 rows
F383353 E 58 STMTTOKEN 1 to 2012-02-02 f2Plan --- rows
F464418 U 59 PARENT_PLANNO 3 to 2011-02-03 f2Plan 3 rows
GDB0135 E 46 BIND_TIME 5 to 2006-02-17 f2Plan --- rows
GDB0178 E 59 PARENT_PLANNO 3 to 2011-07-12 f2Plan --- rows
GDB0275 E 49 PRIMARY_ACCESSTYP 8 to 2007-10-09 f2Plan --- rows
GOWM200 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan --- rows
F890588 E 46 BIND_TIME 4 to 2001-07-19 f2Plan 5 rows
OPTHINT E 51 TABLE_TYPE 28 to 2004-12-13 f2Plan --- rows
A634011 E 58 STMTTOKEN 1 to 2006-10-20 f2Plan --- rows
A533734 E 58 STMTTOKEN 4 to 2008-02-08 f2Plan --- rows
A588168 E 58 STMTTOKEN 2 to 2006-10-19 f2Plan 0 rows
A484692 U 59 PARENT_PLANNO 1073 to 2011-02-17 f2Plan 595 rows
T022527 E 46 BIND_TIME 24 to 2000-09-20 f2Plan 1 rows
*** run error ***
SQLCODE = -904: UNSUCCESSFUL EXECUTION CAUSED BY AN
UNAVAILABLE RESOURCE. REASON 00C90081, TYPE OF RESOURCE 00000100,
AND RESOURCE NAME DW015660
stmt = execSql prepare s2 from :src
with from :src = select count(*), value(max(bind_time), '0001-01-01-00.00.00') f
$#out 20120208 20:39:44
RZ1 DBAF 20120208 20:39:44
S100006 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 U 59 PARENT_PLANNO 882 to 2012-01-18 f2Plan 0 rows
S101869 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S103931 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S107887 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
$#out 20120208 20:35:05
RZ1 DBAF 20120208 20:35:06
DB2OSC U 64 MERGN 2 to 2012-01-30 f2Plan --- rows
DB2OE U 64 MERGN 0 to 0001-01-01 f2Plan --- rows
A523593 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A168658 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan --- rows
A188662 U 59 PARENT_PLANNO 19 to 2010-01-13 f2Plan 5 rows
A223522 E 59 PARENT_PLANNO 4 to 2011-09-07 f2Plan --- rows
A230450 E 59 PARENT_PLANNO 226 to 2012-01-13 f2Plan 10 rows
A273818 U 59 PARENT_PLANNO 26 to 2010-06-08 f2Plan --- rows
A377027 U 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
A426625 E 58 STMTTOKEN 449 to 2009-05-26 f2Plan 114 rows
*** run error ***
SQLCODE = -206: BIND_TIME IS NOT VALID IN THE CONTEXT WHERE
IT IS USED
stmt = execSql prepare s2 from :src
with from :src = select count(*), value(max(bind_time), '0001-01-01-00.00.00') f
$#out 20120208 20:34:45
RZ1 DBAF 12/02/08 20:34:45
CMNBATCH U 59 PARENT_PLANNO 583965 to 2012-02-08 f2Plan 0 rows
$#out 20120208 20:33:29
RZ1 DBAF
CMNBATCH U 59 PARENT_PLANNO 583965 to 2012-02-08 f2Plan 0 rows
$#out 20120208 20:32:15
S100006 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S100447 U 59 PARENT_PLANNO 882 to 2012-01-18 f2Plan 0 rows
S101869 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S103931 E 58 STMTTOKEN 0 to 0001-01-01 f2Plan 0 rows
S107887 E 59 PARENT_PLANNO 0 to 0001-01-01 f2Plan 0 rows
$#out 20120208 20:30:19
*** run error ***
SQLCODE = -305: THE NULL VALUE CANNOT BE ASSIGNED TO OUTPUT
HOST VARIABLE NUMBER 2 BECAUSE NO INDICATOR VARIABLE IS SPECIFIED
stmt = execSql fetch c2 into :pCnt, :pTst
with into :pCnt = 0
:pTst =
$#out 20120208 20:27:20
$#out 20120208 20:26:10
$#out 20120208 20:25:30