by Vikram Khatri | Jul 27, 2025
When it comes to the world of online gambling, not all platforms are created equal. Some promise the moon but deliver little more than a handful of lukewarm chips. Others, however, manage to strike a balance between user experience and game variety that can actually...
by Vikram Khatri | Jul 27, 2025
Le monde des casinos en ligne ne cesse de se développer, offrant aux joueurs une multitude d’options pour s’amuser et tenter leur chance. Parmi les plateformes les plus populaires, Vegas Plus se distingue par son interface conviviale, sa large sélection de jeux et ses...
by Vikram Khatri | Jul 27, 2025
Avec l’essor fulgurant des jeux en ligne, de plus en plus de joueurs cherchent des plateformes fiables et divertissantes pour tenter leur chance. Gratorama s’impose comme l’une des options les plus populaires sur le marché français. Mais...
by Vikram Khatri | Jul 17, 2025
Lorem ipsum dolor sit amet consectetur adipiscing elit. Quisque faucibus ex sapien vitae pellentesque sem placerat. In id cursus mi pretium tellus duis convallis. Tempus leo eu aenean sed diam urna tempor. Pulvinar vivamus fringilla lacus nec metus bibendum egestas....
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...
