by Vikram Khatri | Sep 30, 2019
How to build Kubernetes 1.15.4 on CentOS 7.6? Sharing the content – which is part of the my upcoming book “Mastering Service Mesh Architecture” Check...
by Vikram Khatri | Dec 15, 2017
How to find the total number of database partitions and range (data) partitions held by a table? Here is the query: select t.tabschema SCHEMA, t.tabname TABLE, (select count(*) from syscat.dbpartitiongroupdef pgs where pgs.dbpgname = ts.dbpgname) DB_PARTITIONS,...
by Vikram Khatri | Dec 15, 2017
For example: I get an error creating a table or accessing a table space. create table tpcds.vikram ( c1 int not null primary key, tx_date date not null, c2 char(10), c3 timestamp(9) default current timestamp implicitly hidden, c4 smallint default current member...
by Vikram Khatri | Dec 14, 2017
Usually we run uptime command in Unix to find the uptime of the server. But, what about DB2 database? How long it had been working? db2 “select db_conn_time from table (mon_get_database(-2))” The db2pd -d <database> – –> will also tell...
by Vikram Khatri | Dec 7, 2017
The size of the database can be determined by calling CALL GET_DBSIZE_INFO(?, ?, ?, 0); When we call above Db2 procedure, it also populates information in SYSTOOLS.STMG_DBSIZE_INFO table. We can write the following query to properly format the results and get the info...
by Vikram Khatri | Dec 6, 2017
Using HPU to unload data from source and transferring that data over sockets and using native LOAD to load the data. Also, partitioning is changing. A simple script that counts the number of rows and rate at which the LOAD is going. #!/bin/bash prevRows=0 while true...
by Vikram Khatri | Sep 28, 2017
The Db2 Warehouse client container provides a toolkit that has very nice utility scripts that can be downloaded from http://ibm.biz/db2warehousetools . The list of tools available in the tool kit are shown as below: dbsql – This is like Db2 CLP but based upon Netezza...
by Vikram Khatri | Aug 17, 2017
Some utility scripts that are handy when managing pureScale or DPF cluster. runall scripts Use runall script to commands on all hosts. This way, it is easier to run commands in a single command rather than to type many different lines. #!/bin/bash...
by Vikram Khatri | Aug 16, 2017
I can not put a name to a customer but they spent millions to port their data warehouse to Hadoop and 1 year later rolled everything back to the Db2 again since their results were not matching and the data was getting lost. This is a classic example of misuse of the...
by Vikram Khatri | Aug 16, 2017
ERROR: DBI20122E The instance was not created or updated because the following netname does not exist: “node01.zinox.com”. The above error might come from different reasons but our case was due to misplaced entries in the /etc/hosts file. The natural...
by Vikram Khatri | Aug 10, 2017
C Mohan, IBM Fellow Mohan gave his opening key note address at the 37th IEEE International Conference on Distributed Computing Systems (ICDCS) in Atlanta (USA) on 6 June 2017. A new era is emerging in the world of distributed computing with the growing popularity of...
by Vikram Khatri | Aug 8, 2017
A Fortune article by Barb Darrow. Few interesting highlights: IBM used 64 of its own Power 8 servers—each of which links both general-purpose Intel microprocessors with Nvidia graphical processors with a fast NVLink interconnection to facilitate fast data flow between...
by Vikram Khatri | Jul 28, 2017
One of my colleague Mukesh V Desai did backup tuning for a pureScale customer and just by making the following change, reduced the backup time from from 4.5 hours to 30 minutes. Original config: Number of buffers = 8, Parallelism = 4 and Compress = YES New Config:...
by Vikram Khatri | Jul 7, 2017
Most of the utility scripts here are given for Linux using bash shell. You can use them after making syntax changes from bash to ksh. Most of the script require that you create a node information file in /root/bin/backup/ip.txt. A sample /root/bin/backup/ip.txt is...
by Vikram Khatri | Jun 22, 2017
DSM new release announced on June 22,...
by Vikram Khatri | Jun 22, 2017
I just wrapped a very large PoC for BLU with DPF with very high ingestion rate (110K messages per second) and as well as very high volume point queries (1500 queries per second) and I used the following queries to measure the various parameters and optimum tuning. The...
by Vikram Khatri | Jun 8, 2017
It is recommended that you always update RSCT / TSA from db2 software media and not from IBM Fix Central. The reason – DB2 is tested and certified with the version that ships with the DB2 software. If you go to server_t/db2/linuxamd64/tsamp and run db2cktsa...
by Vikram Khatri | May 19, 2017
In db2diag, you may see this message – No product license found. Sample output: 2017-05-19-13.00.58.511626-240 E2575E1007 LEVEL: Severe PID : 35363 TID : 70366589481392 PROC : db2start INSTANCE: purf01 NODE : 000 HOSTNAME: va33dlvudb001 FUNCTION: DB2 UDB, high...
by Vikram Khatri | Mar 19, 2017
Hang Issue due to SMAP While creating DB2 pureScale instance, it appears that the node becomes unresponsive under RHEL 7.2. If you reboot the node and look at the /var/log/messages, you may notice these several messages: kernel:BUG: soft lockup – CPU#1 stuck for...
by Vikram Khatri | Mar 16, 2017
More and more customers are now asking for some way to check the health of the DB2 pureScale system. Let’s just focus on few early diagnostics before we jump to the deep exploration at the SQL statement level. This is just akin going to primary health care...
