0

My objective is to see the size of Audit Buffer size, normally I would use below command on my Db2 instance

db2 get database manager configuration | grep AUDIT_BUF_SZ

But now I need to do it remotely over an Ubuntu 18 system which has my Db2 instance. For SQL query execution I used ibm_db library, an example of which is below

select="select * from department"
stmt_select = ibm_db.exec_immediate(ibm_db_conn, select)
cols = ibm_db.fetch_tuple( stmt_select )
print(cols[0])

So I need to know is there any way of getting the output of my command that can be implemented through Python, else any other library that can come in handy for this.

1 Answer 1

2

Use the SYSIBMADM.DBMCFG administrative view for this.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.