
All posts
- Sort by:
- Date
- Title
- Likes
- Comments ▼
- Views
Getting Error code: -551 (CDJSN1156E failed to execute function 'Enable') when enabling JSON environment
We are seeing multiple reports of this issue so trying to document the behavior here. Here is the repro on Db2 11.1 Mod 4 Fix Pack 4 db2inst1@machine007:~/sqllib/json/bin> ./db2nosql.sh -p 50001 -db primet01 JSON Command Shell Setup and Launcher.
This batch script assumes your JRE is 1.5 and higher. 1.6 will mask your password.
Type db2nosql.sh -help to see options
IBM DB2 NoSQL JSON API 1.1.0.0 build 1.4.246
Licensed Materials - Property of IBM
(c) Copyright IBM Corp. 2013 All Rights Reserved. nosql>Type your JSON query and hit... [More]
Tags:  error -551 code: json |
PROBEVUE: DETECT FILE DESCRIPTORS LEAK
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]
|
Why the Db2LUW Recover Database is not being able to pickup latest backup image
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 |
How to debug the reason of a gpfs install failure during the installation of pureScale
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 |
Many 'sqlpshrScanClose, probe:90444' db2diag.log message on v11.1m3fp3 and v11.1m3if1
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]
|
How to stop or force AutoRunstat off while its running?
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 |
db2haicu hang at 'Adding HADR database ... to the domain' in primary database with DB2 V11.1 and RHEL 7.2-7.4
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 |
Posssilbe reasons why Db2LUW connections are slow
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 |
How to check if a db2luw registry variable is currently effective or not
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 |
In Db2LUW how to do a SSL loopback catalog
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 on how to rebuild a Db2LUW database
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 diagnostic dumps
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 |
How to do an incremental database restore with rebuild option
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 |
How to insert data in desired sequence
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 |
DB2 : Identify tables consuming most space in a tablespace
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 |