Pin Up Casino - Azərbaycanda onlayn kazino Pin-Up ▶️ OYNA Содержимое Pin Up Casino-dan faydaları və nəticələriPin Up Casino-da qeydiyyatdan keçmək və oyunlara baxım Pin Up Casino Azərbaycanda populyarlaşan onlayn kazino veb-saytıdır. Pin Up və Pinup...

2025 Deneme Bonusu Veren Siteler - Çevrimsiz Bahis Bonusları ▶️ OYNAMAK Содержимое Çevrimiçi Bahis Siteleri ve İhtiyacınıza Uygun Deneme BonuslarıDeneme Bonusları Kullanırken Dikkat Edilmesi Gereken NoktalarEn İyi Çevrimsiz Bahis Siteleri ve Bonuslar...

Onlayn kazino Betandreas - canlı kazino təcrübəsi ▶️ OYNA Содержимое Betandreas Casino Az: Live Casino TəcrübəsiLive Casino TəcrübəsiBetandreas-da qeydiyyatdan keçmək və oyun seçimiLive casino xidmətləri və onların təhliliBetandreas-da oynayış və...

Mostbet AZ - bukmeker ve kazino Mostbet - Giriş rəsmi sayt ▶️ OYNA Содержимое Mostbet AZ-də qeydiyyatdan keçmək və hesab açmaqMostbet-də idman mərcləri və kazino oyunlarıMostbet AZ-də mərclər mostbet giriş saytına daxil olmaq üçün ən etibarlı yol mostbet...

Vegasino casino en ligne en France - avis et retours ▶️ JOUER Содержимое Les avantages d'un casino en ligne françaisAvantages spécifiques du Vegasino casino en ligneLes jeux proposés par VegasinoLes jeux de tableLes jeux de machine à sousLes conditions...

Betify Casino - Avis & Bonus exclusif (2026) ▶️ JOUER Содержимое Les avantages de jeu au Betify CasinoLes avantages de jeu au Betify CasinoLes conditions pour obtenir le bonusLes retours des joueurs sur le Betify CasinoLes avantagesLes inconvénients...

Ice Casino Polska – Jak wypłacić wygrane w Polsce ▶️ GRAĆ Содержимое Metody wypłaty wygranych w Ice CasinoWypłata wygranych za pomocą portfela elektronicznegoProces wypłaty pieniędzy w kasynie onlineBezpieczeństwo wypłatCzas oczekiwania na wypłatę...

Casibom Casino - Güvenilir Online Casino Giriş Adresi ▶️ OYNAMAK Содержимое Casibom Casino Hakkında Genel BilgilerCasibom Casino'da Güvenliği Nasıl Kontrol Ediyorum?Casibom Casino'da Oynarken Ne Tercih Ediyorum? Casibom, en güvenilir online casino giriş...

WinSpirit Online Casino Australia - Fast Withdrawals ▶️ PLAY Содержимое Reliable and Secure Banking OptionsWhy Choose WinSpirit for Your Banking Needs?Effortless Withdrawal ProcessWinSpirit Casino Reviews: A Testimonial to Our Effortless Withdrawal...

Guía de casinos en línea en Argentina ▶️ JUGAR Содержимое ¿Cómo elegir el mejor casino en línea para ti?Los mejores casinos en línea para jugadores argentinos Si estás buscando un lugar donde jugar a tus juegos favoritos de casino online, has llegado al...

Casinos online sin licencia España - selección de plataformas con juegos variados ▶️ JUGAR Содержимое Casinos online sin licencia España: una guía para jugadores¿Qué son los casinos online sin licencia?Plataformas de casinos online con juegos variados Si...

1xbet официальный сайт и рабочее зеркало – вход на 1хБет ▶️ ИГРАТЬ Содержимое 1хБет: Официальный Сайт и Рабочее ЗеркалоКак скачать 1xbet?Официальный Сайт 1хБет: Как Войти и Начать ИгратьКак зарегистрироваться на 1хБет Если вы ищете официальный сайт 1хБет...

GetX – официальный сайт казино онлайн Гет Икс (2026) ▶️ ИГРАТЬ Содержимое GetX – Официальный Сайт Казино Онлайн GetX (2026)Преимущества Игры В Онлайн Казино GetXБыстрый доступ к игре Если вы ищете надежное и безопасное онлайн-казино, где можно играть в...

Spillutvalg på norske nettcasino ▶️ SPILLE Содержимое Velg rett nettcasino for dine behovSpillutvalg for begynnere og profesjonelle Det er ingen hemmelighet at norske casino har blitt en stor suksess i Norge. Mange norske spillere velger å spille online...

Mostbet Online Casino - Step-by-Step Registration Process ▶️ PLAY Содержимое Getting Started: Creating an AccountImportant: Read the Terms and ConditionsVerifying Your Account and Making a DepositStarting Your Gaming Experience: Choosing a Game Are you...

Top online casino’s in België ▶️ SPELEN Содержимое België's Beste Online CasinosOnline Casino België LijstTop 5 Online Casinos voor België Als je op zoek bent naar een online casino waar je veilig en verantwoord kunt gokken, ben je bij ons aan het juiste...

Пин Ап казино - Официальный сайт Pin up играть онлайн | Зеркало и вход ▶️ ИГРАТЬ Содержимое Пин Ап казино - Официальный сайтПреимущества Pin Up CasinoИграть онлайнВыбор игрЗеркало и вход в Pin Up Казино Если вы ищете надежное и проверенное казино, где...

Vodka онлайн казино - обзор ▶️ ИГРАТЬ Содержимое Вода онлайн казино: обзорПреимущества онлайн казино В последние годы интернет-казино стали все более популярными, и это неудивительно. Ведь они предлагают игрокам комфорт и свободу, которые не могут быть...

Олимп Казино - Бонус 150 000 KZT и 250 FS Olimp Казино ▶️ ИГРАТЬ Содержимое Большой Бонус для Новых Игроков250 FS для Взятки на ВысотуКак получить 250 FS? Если вы ищете новый игровой опыт, то олимп казино - идеальное место для вас. Это популярное...

Betify Casino - Avis & Bonus exclusif (2026) ▶️ JOUER Содержимое Présentation du casino BetifyLes avantages du casino BetifyAvantages et inconvénients de Betify CasinoBonus de bienvenueConditions du bonusJeux et logicielsLes logicielsPlateforme de...

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 https://github.com/servicemeshbook/byok

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)...

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...

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 the uptime...

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...

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...

The SQLs while DB2 is up and running can be captured in different ways such as: Query column STMT_TEXT from table functions such as MON_GET_ACTIVITY or WLM_GET_WORKLOAD_OCCURRENCE_ACTIVITIES, and MON_GET_ACTIVITY_DETAILS --> SQLs that have been submitted but not...

Here are two templates that one can use to make Automatic Client Reroute to work properly in a HADR environment. Please note that these instructions are only valid for HADR pair in which the second machine is ready to takeover. I will publish / update this article...

This is about how to rebuild TSA resources in HADR environment if you have used db2haicu in past but added resources such as tie-breaker disks that are not supported by the db2haicu tool. So, in case of a difficulty - how do you get back soon. You can always recover...

When you get errors like this: "SQL1517N db2start failed because the cluster manager resource states are inconsistent." or something like "Cluster manager resource states for the DB2 instance are inconsistent. Refer to the db2diag.log for more information on...

RSCT License Issue $ db2start 128 SQL1677N  DB2START or DB2STOP processing failed due to a DB2 cluster services error DATA #9 : SQLHA Remote Command Output, PD_TYPE_SQLHA_COMMAND_RESPONSE, 3508 bytes commandResponse->callRC: 0x00000000 commandResponse->output:...

GPL Compile Problem When you try to install DB2 pureScale on Linux platform (RHEL or SLES), you may receive the error. ERROR: A missing Linux package is preventing the compilation of the IBM General Parallel File System (GPFS) Portability Layer (GPL) module. The...

If you try to add a member to a running cluster, you may get the following db2start error. ERROR: The "db2start add MEMBER 2 hostname node04.purescale.ibm.local netname node04.purescale.ibm.local port 0 -iupdt" command failed with the return code: "55", and following...

One of my most favorite icons on GNOME has been Dropline Neu! for many years and I still have a copy of it since 2006. It is now hard to find. Download ICON-DroplineNeu.tar.bz2 And, copy to /tmp directory # cd /usr/share/icons # tar xvfj /tmp/ICON-DroplineNeu.tar.bz2...

If you need to drop a member in DB2 pureScale, the db2iupdt process requires that member to be available during the drop process. But, the actual world is more cruel than what db2iupdt thinks. For example: If you have a 3 member cluster and someone moved / migrated...

If you install DB2 pureScale in Linux, the Fast I/O Fencing does not get enabled automatically. If you refer to Knowledge Center for DB2, you will find number of steps to enable fast I/O fencing. After DB2 instance is created and databases are created, I usually run...

Use dmidecode -t slot to find out the slot numbers that are in USE and the Bus Address. Use that bus address in lspci -s <busaddress> to find out what is in the slot. For example: I have NIC in slot-7, Q-Logic in Slot - 2 and Mellanox in Slot - 3. I can then...

A FC card has a World Wide Name (WWN). Card may have two ports and each port is known as by its World Wide Port Name (WWPN). I seemed to have confused myself with WWN, WWNN and WWPN and didn't understand the difference as this is not my topic. In the example below :...

In order to be a successful DB2 pureScale DBA, one has to learn how to diagnose and fix TSA. Though, this is not necessary but it will help to fix cluster in case you run into situation when you get messages like "SQL1517N db2start failed because the cluster manager...

This is for for my own reference and does not constitute any recommendations. VIO Server Changes Verify flow_control is set to yes - This is the default setting lsattr –El ent0 | grep flow and lsattr –El ent1 | grep flow chdev -l ent0 –a flow_control=yes chdev -l ent1...

It is possible to avoid tie breaker disk in pureScale and HADR just by following a simple majority rule. You need a tie breaker disk in pureScale and HADR if number of hosts are even. So, in HADR you have only two nodes so your need a tie breaker disk. But, even in...

Reset RSCT Configuration (completely remove all cluster configuration) # /usr/sbin/rsct/install/bin/recfgct Change the tie-breaker # chrsrc -c IBM.PeerNode OpQuorumTieBreaker='Operator' Find out which tie-breaker is in use # lsrsrc -c IBM.PeerNode OpQuorumTieBreaker...

Read reservations: /usr/bin/sg_persist --in --no-inquiry --read-reservation --device=/dev/sdc /usr/bin/sg_persist --in --no-inquiry --read-key --device=/dev/sdc Prepare for cancel: /usr/bin/sg_persist --out --no-inquiry --register --param-sark=0x1 --device=/dev/sdc...

I had documented same for zLinux here http://www.zinox.com/archives/182 When you use a tie-breaker disk in pureScale or in HADR, it must be Write Exclusive Registrants Only. It is a good idea to test if the tie-breaker disk is working as expected or not. The...

RSCT Version [root@node02 iscsi]# /usr/sbin/rsct/install/bin/ctversion -b rliss005a 3.1.5.5 14182.07:51:59 TSA Version [root@node02 iscsi]# /usr/sbin/rsct/bin/samversion rsa322s008a 3.2.2.8 Jul 18 2014 10:02:26 # lsrsrc -Ab -c IBM.CHARMControl # lssamctrl GPFS Version...

How to find if the shared disks being used for pureScale are SCSI-3 PR capable or not after creation of pureScale install. # /usr/lpp/mmfs/bin/mmlsconfig minReleaseLevel,usePersistentReserve minReleaseLevel 3.5.0.11 usePersistentReserve no    

If you want to clean the system having pureScale or want to drop pureScale instancefor installing a fresh instance of pureScale, follow on: Obviously, you want to follow the steps given in DB2 Knowledge Center first. If you have a working pureScale install where you...

These note are valid only on AIX. Please note the following: There are two types of updates - System update (applying eFixes or Service Packs on AIX). If you are applying the system packs or efixes on a pureScale host, please call the DBAs and work in coordination so...

In DB2, the file system caching is turned on by default for SYSTEM or USER TEMPORARY table spaces but turned off other DMS. If you have LOBS (CLOB, BLOB or XML) in a table, try to follow these guidelines: Put LOBS in a separate table space. Use ADMIN_MOVE_TABLE to do...

When adding a member through db2iupdt command, you may get an error something like this: ERROR: The "db2start add MEMBER 1 hostname hostc.zinox.com netname hostc-r.zinox.com port 0 -iupdt" command failed with the return code: "4", and following error: "04/10/2016...

When you do sudo to another user, you may have to do extra things to get X display working or any GUI working. Many organizations do not allow root login so X window cookie does not get generated and hence GUI does not work. I prayed to Google God for solutions and...

A third party single sign-on application was installed on two nodes of db2 cluster having 2 CF and 4 members. The pureScale cluster started showing signs of trouble and naively, we did not think the impact of the software installed. This single sign-on software (as we...

Client Connection Attributes When you establish connection to DB2 using Java programs, you need 5 minimum attributes DB2 server name or IP address Port Number (socket connection) Database name User ID Password This could be defined as a URL in the Java program such...

When we install DB2 instance as a pureScale, we can specify the name of the mount point by using option instance_shared_mount. If we do not use this option, the mount point name is generated by the db2icrt command as /dv2sd_<timestamp> and this may not be the...

If DB2 was processing a very long running transaction (say updating millions of rows) and for some reason like power failure, server goes down. When you start the server and activate the database, it may take a long time as it needs to do the crash recovery. This is...

If you run into LOG FULL condition in DB2 with SQL error code: SQL0964C, you need to increase the size of either of the following: LOGPRIMARY, LOGSECOND or LOGFILSZ. So, you change that even after that you again run into LOG FULL condition. What is happening? You can...

These instructions are for changing the IP address in a pureScale cluster. Please remember that the IP address can be changed easily for DB2 but it is RSCT and GPFS that requires special handling to change the IP address. You change the IP address one by one in a...

I started using Google from very early on (Since Feb 1998) and since then it has remained my home page. Needless to say that I now consider Google as God since it knows everything. In my day-to-day conversation, I ask people "Did you ask Google God?" So the two words...

Say for example, you are creating a file system using db2clutser command in DB2 pureScale and it fails with this error: # db2cluster -cfs -create -filesystem db2data1 -disk /dev/dm-2 -mount /db2data/data1 There was an internal db2cluster error. Refer to the diagnostic...

One of less known but very useful feature of DB2 is the post login script after an application makes a connection. DB2 database has a configuration parameter known as CONNECT_PROC which is name of the database procedure which will be executed everytime someone...

After specifying entries in db2dsdriver.cfg, the db2cli validate -dsn >dbname> does not show that the client actually read db2dsdriver.cfg file. For example: A sample db2dsdriver.cfg file: db2psc@node01:~/pot_purescale/04application> db2cli validate -dsn psdb...

Management of my shoe-closet computer center requires that I should take some steps to protect the data by taking a backup. In last 10 years, I never took any backup and luckily I was never in the situation to have lost the data. The servers kept on running and...

Usually enterprise distributions like SLES or Redhat are slow to adopt latest in consumer products such as CUPS used for printing. The version of cups on SLES 11 SP2 is 1.3 when the latest version at the time of writing this is 1.6.2. The older version 1.2 uses older...

http://www.novell.com/support/kb/doc.php?id=7003097  

In today's world, due to some dishonest populace who are like parasites living on somebody's else blood, implemenation of security comes at a heavy price and it has more problems than solutions. It is also a great business model for the companies to exploit...

When taking a DB2 backup, if you get the following error: $ db2 backup database <dbname> to /backup compress SQL1224N The database manager is not able to accept new requests, has terminated all requests in progress, or has terminated the specified request...

When database is converted from circular log to archive log, it will force the backup of the database which is a good thing. But, sometime, we do not want to do it. Say, when we are in test environment like testing upgrade from DB2 ESE to DB2 pureScale. If database is...

Best practice or things that appear to work well in a two nodes cluser or a single node (just with one DB2 and a CF). The cthats subsystem handles heartbeating between nodes. When in steady state, there is a ring formed where each member is sending heartbeats to their...

For example, we have a two (or more) nodes DB2 cluster having a shared database and we want to configure Optim Perfromance Manager (OPM) for the database monitoring. The questions comes - which node should OPM connect to and what if that node is down for any reason....

In DB2 pureScale, when you run the command db2instance -list, it shows the DB2 pureScale topology and which member is up and running and which CF is in PRIMARY mode and which one is in PEER mode. If you want to change the role of CF from PRIMARY to PEER or from PEER...

Work Load Balancing In order to utilize DB2 automatic Work Load Balancing for JBoss application, some changes need to be made in the JBoss JDBC driver manager configuration. Myth - Most people think that work load balancing is done by the DB2 pureScale and it is not...

DB2 timestamp can show micro seconds and I was trying to generate an excel report showing elapsed time between 2 DB2 timestamps and had to work a little bit to write this excel formulae. Timestamp (Cell B3) = 2013-03-04-13.38.26.677483 Timestamp (Cell C3) =...

On AIX, how to find out the uDAPL version? # lslpp -la "*udapl*" Fileset Level State Description ---------------------------------------------------------------------------- Path: /usr/lib/objrepos udapl.rte 7.1.1.15 COMMITTED uDAPL Path: /etc/objrepos...

In DB2 pureScale if a node goes down, it is started on another host in a light mode just to do the crash recovery. When the home host becomes available, the host should fail back to its home host seamlessly. For example: This is a sample output from the db2instance...

After you install DB2 pureScale, it is a good idea to check the GPFS tie breaker and to see what DB2 install did to set the GPFS tie breaker. Run the following command. # db2cluster -cfs -list -tiebreaker The current quorum device is of type Majority Node Set. The...

During DB2 pureScale install, you must have given the tie-breaker disk device name. It is a good practice to check if that disk was in fact used as a tie-breaker disk or not. # db2cluster -cm -list -tiebreaker If the output from the above command is...

While installing DB2 pureScale, if you receive the error: DBT3542E  An instance management task failed because the db2prereqcheck utility encountered an internal error. Reason code: "2", the fix is simple. Edit your /etc/hosts file and check if you have...

As I am exploring new features of DB2 10.1, there are some fun things that I can do. Example-1: A table has rows in it. You want to make those rows invisible to all including you. Do this. $ db2 "select count(*) from ps_table" --> You see rows in this...