CODEWITHSUNDEEP
db2ibm-midrangedb2-400
Hena
Hena

Reputation: 21

get admin config in db2 iseries

I am working on db2 AS400 v7.1. Could you please tell me database configuration concept in db2 as400 similar to db2 LUW? I achieved using below command:

db2 UPDATE DB CFG USING CONNECT_PROC **schema.stored_Procedure**

usage: helps to run stored_Procedure each time when user logs in.

Upvotes: 0

Views: 263

Answers (1)

Satya
Satya

Reputation: 583

If you are using JDBC/ODBC for connecting to database (DB2 for i), you can use user exit QIBM_QZDA_INIT which is equivalent of connect_proc in DB2 LUW.

Link to IBM documentation for more details.

https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/rzaii/rzaiimstsmpinitcl.htm

https://www.ibm.com/support/knowledgecenter/en/ssw_ibm_i_71/rzaii/rzaiimstexdb.htm

Upvotes: 2

Related Questions