This small script will keep a list of file descriptors obtained by calls like 'open()', accept(), socket() and store them in an associative array. When a given fd is closed it will be marked 'closed' in the array. Every few seconds (1h by default) the script will output the list of file descriptors in use by the process. Note that IOCP (IO Completion Port) related file descriptors are not handled as probevue doesn't have access to those calls. Some examples of output:   -- open_files array (pid 11403730) [END PROBE]:   key  ... [More]

The  simplest  form of  recover  database  command, db2 recover  database  <db-name> recover  the latest  backup image  and rollforward to the end of logs using all default settings.   The complain  is why  this  command is not picking up  the latest backup image. The  reason is mostly  on history  file  as  recover database  depend on history  file to  pickup the  backup images.   In this  specific customer... [More]

Tags:  history database db2luw recover ibm-blog

This is a simple case demonstrating how to find out the reason of a gpfs installation failure during setting up a pureScale environment. It is a Redhat Linux 7.4 server, I was trying to install pureScale v11.1.4.4 on it.   However, I saw this error and db2_install aborted: <skipped> Task #27 start Description: General Parallel File System (GPFS) Estimated time 100 second(s) Task #27 end DB2 Setup is undoing the changes made to your computer during this installation.  Undo complete. A major error occurred while installing "DB2 Server... [More]

Tags:  ibm-blog

Symptom If you are using v11.1m3fp3 and v11.1m3if1, you might have lots of the following error message in your db2diag.log   2019-04-07-15.17.39.594893+480 I24726862E574         LEVEL: Error PID     : 6975                 TID : 47284876207872  PROC : db2sysc 0 INSTANCE: xxxxxxx              NODE : 000            DB   : XX APPHDL  : 0-37450              APPID: xxx.xxx.xxx.xxx.xxxxx.xxxxxxxxxxx AUTHID  : xxxxxx               HOSTNAME: xxxxx EDUID   : 250                  EDUNAME: db2agent (XX) 0 FUNCTION: DB2 UDB, recovery manager,... [More]

Unfortunately we will not be able to stop a runstats while it is running. This would lead to inconsistent data in the catalog. A "db2stop force" will work ( likely ) at the end of the runstats. So useless. As it didn't worked for you it must be in initial or middle process. What might work, is to revise the priority of the process. That can be done with the parameter util_impact_lim and the command "set util_impact_priority", Please review for... [More]

Tags:  runstat autorunstat force

Symptom After db2haicu in standby database without any issue, if db2haicu hangs at 'Adding HADR database ... to the domain' in primary database, you might need to check if it's hitting RSCT APAR IJ00283 by checking db2diag.log and /var/log/messages like as follows.   1. db2haicu output in primary DB... [More]

Tags:  rsct tsamp hadr db2haicu

Following  is a good  document  on  possible reasons  why  db2 connections could  be slow, http://www-01.ibm.com/support/docview.wss?uid=swg21455469   I  just  wanted to highlight  one more area to consider   for the connect slowness. Sometimes a  database   which  might not be continuously  in use. Connections are happening  in low numbers and then being terminated  and there is a silent  period  after that before  some more... [More]

Tags:  slow db2luw ibm-blog db2 connection

This  is a common question we face. A  db2   registry  was set. Then, a  problem faced. The  collected data showed  it's   set currently  from  db2set  command. But,   how to  know if  the  registry was  in effect  and  not  just  showing in the output of  db2set   command ? Manyt  of the db2 registry settings are  not  effective  until  and unless   the instance is ... [More]

Tags:  registry ibm-blog effective db2set env_get_reg_variables

Just wanted to share an example with sample database  on how to do a SSL  loopback in Db2LUW. db2 catalog tcpip node LOOPNODE  remote  MYHOST  server 21212 security ssl That  shows, $ db2 list node directory  Node Directory  Number of entries in the directory = 1 Node 1 entry:  Node name                      = LOOPNODE... [More]

Tags:  ibm-blog loopback ssl db2luw

Basic Guideline for  rebuilding a  Db2LUW database  : Create a  temp directory to store  the  outputs  of  db rebuild and  go to that directory. Save  all the DDLs  for the database  : db2look -d  <db-name>  -a -e -m -l -x -f -o   db2look.out refer :   https://www.ibm.com/support/knowledgecenter/en/SSEPGG_10.1.0/com.ibm.db2.luw.qb.upgrade.doc/doc/t0053156.html Save   config  of the database : db2  get db config ... [More]

Tags:  db2mov ibm-blog db2luw corruption rebuild db2dart ddel

Why db2luw instance went  down suddenly without any associated diagnostic dumps.   This is something  explained as part of different documents   But,  still been asked on this currently. So,   I  thought to write few lines on that.   First of all  we need to understand how db2  dumps any diagnostics when it experience a  crash or,  trap situation. Db2 has it's own  signal handler which  handles the UNIX signals to invoke it's signal handler function/routine... [More]

Tags:  dump trap sigkill db2luw crash adm0503c db2wdog ibm-blog

Here is an example about how to perform an incremental restore with rebuild option. In the original database, we have 2 tablespaces created, TBSP01 and TBSP02. When doing incremental db restore, we are going to restore only one of them. The other one will not be available in restored database.   db2 create db MYDB01 db2 update db cfg for MYDB01 using logarchmeth1 logretain TRACKMOD on db2 terminate db2 backup db MYDB01 to /dev/null db2 connect to MYDB01 db2 create tablespace tbsp01 db2 create tablespace tbsp02 db2 "create table t01... [More]

Tags:  db2

 There are two independent insertions on table T01, one after another. The insertion on table T01 will trigger a stored procedure call which then writes a row into another table T02. Will the sequence of insertions on T01 guarantee the sequence of insertions on T02? Let's take a look into the scenario:   Point in time: A ----------> B --------------------> C           Insert #1 ---------->  calls SP1() ---------> insert #3   Point in time: X ----------> Y... [More]

Tags:  db2

  It is easily possible to identify the amount of space consumed by tables in a given tablespace. This is required when size of tables increases to reach the size limit or makes tablespaces have unequal data distribution which might eventually lead to bad performance mainly for backups.     Lets consider an example and take a look at the top 3 space consuming tables in tablespace 3 :   $ db2 "SELECT substr(a.TABSCHEMA,1,12) sc, substr(a.TABNAME,1,12) tb, SUM(DATA_OBJECT_P_SIZE+INDEX_OBJECT_P_SIZE+LONG_OBJECT_P_SIZ... [More]

Tags:  highest tables size tablespace consumer