Hello All We are in the process of Db2 13 upgrade. We are tuning our work file tablespaces buffer pools. Please share any suggestions/ process improvements. Thanks, Sekhar. ------------------------------ Sekhar ------------------------------
DSNTEP4 uses multi row fetch. This is not supported by Db2 (LUW). (Might be now - wasn't when I tried) OP will need to bind DSNTEP2 (well, the DSN@EP2L (?) DBRM) into the Db2 (LUW) and use that. James Campbell On 26 May 2023 at 18:53, Jaime Fernandez ...
Hi Steve, There is something else you need in order to run SQL from Db2 zOS into a LUW instance. On the mainframe side, your SQL will be proccessed through a certain package. Depending on the interface you try to use, that could be DSNESM68 (Spufi), ...
Hi Steve, You are pretty close yourself. Probably just the packages need to be bound properly to the database. Have a look here https://www.ibm.com/docs/en/db2/11.5?topic=pack-binding-bind-files-after-installing-fix-packs Cheers ------------------------------ ...
I get this message when running in batch. DSNT408I SQLCODE = -805, SQLSTATE = 51002, INVALID APPLICATION STATE FROM DB2 UDB FOR AIX,LINUX,HP-UX,SUN OR WINDOWS TOKENS DSNTEP4.DSN@EP4L 0X1B3BA8330354D7D6 I know I am missing one little ...