Unanswered: DB2 DataBase Autometically disconneting after 30 mins
Thanks in advance
I have a small problem am connecting to my database normally but after 30 mins its disconnecting autometically if i didnot work on that database. but , i want continuos connection to that DB (because am testing the automatic maintenance on this database). Pls suggest me how to over come this situation or pls tell me how to set the cron job to connect the database every 25 mins with example code.
A database is either Active or Inactive. If it is Inactive, it is not taking up resources (memory) on the server and no one is accessing the data. A database can become active by one of two ways. Either the ACTIVATE database command is issued, or when the first connection occurs. When a database becomes active, all of the heaps and bufferpools are allocated. This can take some time, which maybe undesirable when connecting to the database for the first time. The ACTIVATE DATABASE command will bring up the database and allocating heaps and buffperpools so that the connections do not experience the delay of bringing up the database if it is the first connection. If a database have been ACTIVATEd, it will remain active even when the last connection ends.
There is no error msgs in diag.log file. Actulally what happpnening is
db2 connect to <db-name> working normally without any errors and warnings also am working on this db properly without any problem. main problem is if i will not work on this db upto 30 mins then its going to disconnected when am continue the work then its in connected state only.
am getting following msg then disconnected to the database
Shell will time out in 60 seconds.
ksh: Timed out waiting for input.
kcmstr02:/# (Wht does it mean ?)
Here again i have to login to instance to connect the database to work any thing on that . pls guide me to solve this ........
The message indicates that you are automatically disconnected from AIX session. It has nothing to do with DB2 session. Go thru following link for details regarding changing timeout settings for AIX session.