Hi,
Assuming you are using DB2 UDB, here are the answers.
1. Connection pooling can be done at instance level by using dbm cfg parameter NUM_POOLAGENTS. If you give a value of 200, then 200 agents will be residing in the pool for future use.
2. The pool will be maintained by db2 itself. You need to decide on the number of agents in pool, more number of agents in the pool means more memory they occupy....
ramesh jampala
Last Activity: Apr 5 '07, 09:57 PM
Joined: Mar 2 '07
Location:
-
Hi Vikram,
Db2 Connect is used to connect to Host databases like db2 on Mainframes.
Thanks...Leave a comment:
-
Vikram,
From Control center, if the backup image is not visible means it is not there in recovery history file. Choose Manually enter the backup image information radio button. This will allow you to provide the backup image when you know the path where it was stored....Leave a comment:
-
Hi Vikram,
Are you providing the backup image path in the restore command?
If the database is dropped, use the following command for restore...
db2 restore database dbname from backuppath taken at timestampofback upimage into newdbname without prompting
backuppath is where you stored your backup image like c:\db2backups...Leave a comment:
-
Catalog table for Tablespace size information
Hello Gurus,
I know that we can get tablespace used and free page information using " db2 list tablespaces show detail" command. But this information should be stored somewhere in catalog tables. If we can retrieve this information only using snapshot functions, where this information is physically stored.
Thanks -
Hi Srinu,
This is expected only. It is asking for SYSLH21E means it is 31st package. maximum SYSLH packages are only 30. You can solve this problem by including commit statements after some rows are updated in your application or closing handles or cursors. But if you want to commit only after all records are updated, you can try with more SYSLH packages but as of my knowledge only 30 packages can be bound.
Ramesh
IBM...Leave a comment:
-
Hi,
I dont think this is problem with query too long. SQL804N is saying that your Host varaiables are invalid or you have modifed the output of precompilation. Verify your host variables....Leave a comment:
-
Hi,
Your databases has only 3 packages of this kind.
They are SYSLH200,201,20 2.
But your query requires one more additional package SYSLH203. If you are a DBA, go to SQLLIB/BND directory then issue the following command
db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG 5
If you are application programmer, contact your DBA to perform above bind. You can bind upto...Leave a comment:
-
Hi Manish,
Use the command db2 get dbm cfg
The SVCNAME gives you the service name or direct port number. If it is a service name then go to /etc/services on the system , there you can find port number corresponding to this service name.Leave a comment:
No activity results to display
Leave a comment: