I have to unload data from a backup to check the content . It is very simple why do you making a thread for that ?
The table is sysibm.sysroutines ok
as two columns are LOB it can't be done via unload backup ;-(
no problem , create a clone table , make obidxlat of the 3 backups (base tables and 2 lob tablespaces) rebuild indexes for LOB. and I will have my information in 20 minutes.
I create a table sysroutines like sysibm.sysroutines , prepare my obidxlat , run them , page are copied in the 3 TS.
rebuild index for parse_tree LOB ok
rebuild index for TEXT lob --> abend ;-(
verify my obid , output obidxlat , ....
check in the catalog , finally I find the cause , the LOB ts for TEXT is a 8K pages and mine is a 4K pages. (the create like doens't manage it , also in V12)
I redefine object with the good page size , redo my obidxlat , redo the build index
and finally find my information .
It takes more than 2 hours for this simple task ,
fortunately , It is not for a incident or a problem solving .
I have a little question for you .
have you an automatic procedure to do this task ?(without third-party tool)
can you check it with sysibm.sysroutines ?
How many time do you need to get the information ?