Db2 - L

 View Only

Latest Discussion Posts

  • 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 ...