http://www.dbatodba.com These are the search results for the query, showing results 1 to 15. http://www.dbatodba.com/Forums/db2/609421680/653918784 db2 connect The command above shows which is database you are working. And the command: db2 list active databases, shows all databases active in your instance. No publisher perallis 2009-12-22T17:22:07Z Comment http://www.dbatodba.com/Forums/db2/555202786/370734064 Hi Perallis, I changed db2nodes.cfg content from 0 localhost 0 to 0 elder-notebook 0, where elder-notebook is machine name. Unfortunatelly didn't help much. I droped and recreated the instance and it started to wok. Thanks No publisher elderibeiro 2009-02-15T01:54:02Z Comment http://www.dbatodba.com/db2/problem-resolution/general-errors/sql805n-on-nullid-sys-package There might be instances where applications do not close their cursors after they are done with them. No publisher Perallis 2011-01-25T12:37:26Z Page http://www.dbatodba.com/db2/scripts-db2/python-scripts-to-db2/script-python-to-check-if-db2-instance-is-running Script to check if DB2 instance is running, this script is can be used transparently as a nagios plugin. No publisher Perallis 2009-01-19T15:08:07Z Page http://www.dbatodba.com/db2/how-to-do/hadr-and-tsa No publisher Perallis 2011-01-17T13:37:38Z Page http://www.dbatodba.com/db2/scripts-db2/shell-scripts-to-db2/update-parameter-value-from-all-your-dbs Based on another script, this one can update a parameter value for all the db´s you have in a single instance. To run it, supply parameter name and value. No publisher owindels 2010-02-19T18:54:02Z Page http://www.dbatodba.com/Forums/db2/577874120/811804132 Thanks for the reply .. its working !!!! No publisher sasidred 2014-06-07T16:01:23Z Comment http://www.dbatodba.com/db2/how-to-do/high-availability-options-for-db2-luw 1. Traditional Fail Over 2. DB2 HADR feature 3. Replication 4. GridSCALE No publisher Perallis 2011-01-17T13:33:22Z Page http://www.dbatodba.com/db2/how-to-do/how-to-list-the-db2-products-and-features-installed-on-your-system where DB2 products are installed on your system and list the DB2 product level with db2ls command No publisher Perallis 2009-02-10T12:06:53Z Page http://www.dbatodba.com/Forums/db2/651689481/531160064 Getting the following error for a db , for rest all dbs under the same instance  it's working fine , any ideas anyone ? gb02qap050arcx7.warwick.mebs.ihost.com[/home/db2comm]$ db2 'call get_dbsize_info(?,?,?,-1)' SQL0443N  Routine "*IZE_INFO" (specific name "") has returned an error SQLSTATE with diagnostic text "SQL0444  Reason code or token: *TAMPDIFF, TIMESTAMPDIFF,.../".  SQLSTATE=38553 Regards kanak No publisher kanakaraju 2009-01-20T11:24:17Z Comment http://www.dbatodba.com/db2/scripts-db2/shell-scripts-to-db2/check-if-instance-is-running-fine No publisher Perallis 2008-12-13T16:56:51Z Page http://www.dbatodba.com/db2/db2-not-startint-after-license-add After install license in db2 , db2start no load No publisher araujo70 2010-11-10T12:23:57Z News Item http://www.dbatodba.com/db2/problem-resolution/general-errors/various-db2-failures-may-occur-on-linux-with-kernel-randomize_va_space-1 Memory errors No publisher Perallis 2011-01-26T12:17:46Z Page http://www.dbatodba.com/Forums/db2/441203411/540106462 We are facing an issue in one  environment.We are having  total 3 instances .Under each instance different databases are running. Issue is db2inst2 is consuming 92% CPU usage.Under which XMETA(datastage inbuilt database created by default while installing datastage) is running. I tried different ways to tune the XMETA database. 1.i did reorgchk.reorg of all tables of XMETA 2.setup Archivallogging . 3.Set up the Activity monitor for XMETA and checking the TOP CPU consuming applications and TOP CPU consuming SQLs .Still i could not found the exact solution to brought down the % of CPU usage. NOTE:XMETA is used to store the META data of jobs running on the BCM application. I need your comments on this issue in order brought down the % of CPU usage .Any other ways we can follow to resolve these kind of issues? No publisher kanakaraju 2010-02-18T13:33:13Z Comment http://www.dbatodba.com/Forums/db2/577874120/83430364 OS : RHEL 5 DB2 Version : V9.5 fixpack 5 problem summary : SQL1427N An instance attachment does not exist. I installed db2 version 9.5 fp 5 on linux environment and created the instance db2inst1. Then I started the DB2 process using "db2start". after that when I execute "db2 get dbm cfg show detail " the above error exists. But "db2 get dbm cfg" command is working. Can anyone please suggest how to resolve the issue Regards Sasidhar No publisher sasidred 2013-03-01T17:09:00Z Comment