Як обрати найкраще онлайн-казино в Україні: детальний огляд
З кожним роком індустрія онлайн-казино в Україні стрімко розвивається, пропонуючи гравцям безліч варіантів для розваг та виграшів. Але як не загубитися серед сотень платформ і вибрати надійне та вигідне казино? У цій статті ми розглянемо ключові критерії вибору,...
Як обрати надійний онлайн-казино: стратегічний гід для гравців
За останні роки індустрія онлайн-казино стрімко зросла, і сьогодні мільйони користувачів шукають безпечні та вигідні платформи для азартних ігор. Але як не загубитися у безлічі пропозицій і вибрати саме той ресурс, що гарантує чесність, якість і вигідні умови? Цей...
Як обрати найкращі онлайн-казино в Україні: поради та рекомендації
Вибір надійного онлайн-казино може стати справжнім викликом для багатьох гравців. Величезна кількість платформ, різноманітність ігор і бонусних пропозицій часто збивають з пантелику. Щоб уникнути неприємностей і отримати максимальне задоволення від гри, важливо знати,...
Як обрати онлайн-казино в Україні: розбір нюансів
Вибір онлайн-казино іноді нагадує пошук голки в стозі сіна, особливо коли на горизонті маячать сотні сайтів з обіцянками золотих гір. Український ринок азартних ігор стрімко розвивається, і не кожен гравець знає, на що звертати увагу, щоб не залишитися в програші....
Як обрати надійне онлайн-казино в Україні: розбір з іронією та здоровим скепсисом
Вибір онлайн-казино в Україні може нагадувати пошук голки в стозі сіна, особливо коли реклама ллється рікою, а обіцянки здаються надто солодкими, щоб бути правдою. Якщо ви вже втомилися від шаблонних оглядів, де кожне казино називають "найкращим", а бонуси –...
Вишково: Перлина Закарпаття для туристів і місцевих жителів
Вишково – це мальовниче село, розташоване в Закарпатській області України, яке приваблює туристів своєю унікальною природою, багатою історією та гостинністю місцевих мешканців. Це ідеальне місце для відпочинку, де можна насолодитися чистим повітрям, гірськими...
Оренда будівельної техніки: як не втратити гроші та час
Починати будівельний проєкт без власної техніки — це як йти в казино без грошей: можна, але навряд чи виграєш. Оренда будівельної техніки стала звичайною практикою для багатьох компаній, що прагнуть зекономити на капіталовкладеннях. Проте, не все так просто, як...
Як обрати онлайн-казино: розбір без прикрас
Вибір онлайн-казино часто нагадує пошук голки в стозі сіна, особливо коли реклама кричить про "вигідні умови" і "шалену віддачу". Але чи справді все так райдужно, як малюють? Розберемося, на що варто звертати увагу, щоб не залишитися з порожніми руками і не втратити...
Як обрати найкращі онлайн-казино в Україні: стратегічний гід для гравців
Чи знали ви, що понад 60% українських гравців вважають безпеку та ліцензію найважливішими критеріями при виборі онлайн-казино? У сучасному цифровому світі, де кількість азартних платформ стрімко зростає, важливо розуміти, як відрізнити надійний ресурс від потенційно...
Як обрати найкраще онлайн казино в Україні: повний гід для гравців
Індустрія онлайн казино в Україні стрімко розвивається, пропонуючи гравцям широкий вибір платформ для азартних ігор. Однак, обрати надійне та вигідне казино може бути складним завданням, особливо для новачків. У цій статті ми розглянемо основні критерії вибору онлайн...
Ефективність гомеопатії: сучасний погляд на альтернативну медицину
Гомеопатія вже давно викликає суперечки серед медичних фахівців і пацієнтів. Проте, попри критику, багато людей продовжують звертатися до цього методу лікування, шукаючи безпечні та натуральні способи підтримки здоров’я. В Україні гомеопатія набирає популярності, і...
Роль надійних інформаційних порталів у цифрову епоху
Від хаосу до структури: як обирати джерела інформації У світі, де кожен клік може призвести до лавини неперевірених фактів і маніпуляцій, пошук достовірної інформації стає справжнім викликом. Інформаційний простір нагадує джунглі, де клікбейт — це отруйні ліани, що...
Як обрати найкращі автозапчастини в Києві: поради та рекомендації
Автомобіль — це не лише засіб пересування, а й складна технічна система, яка потребує регулярного обслуговування та заміни деталей. Вибір якісних автозапчастин є ключовим фактором для забезпечення безпеки, надійності та довговічності вашого транспортного засобу. У...
Як обрати найкращий онлайн-казино: поради та рекомендації
Онлайн-казино стали надзвичайно популярними серед любителів азартних ігор, адже вони пропонують зручність, різноманітність і можливість виграти великі суми грошей, не виходячи з дому. Проте вибір надійного та чесного казино може бути складним завданням через величезну...
Як обрати онлайн-казино: розбір без рожевих окулярів
Вибір онлайн-казино часто нагадує пошук голки в стозі сіна, особливо коли навколо стільки блискучих обіцянок і гучних слоганів. Не кожне казино заслуговує на вашу увагу, а тим більше — на ваші гроші. Якщо ви думаєте, що достатньо лише красивої графіки та яскравих...
Цифрова гігієна поколінь: як не потонути в океані інформації
Інформаційний хаос і виклики для кожного віку Занурення у світ новин та медіа дедалі більше нагадує плавання у вирі, де кожна хвиля — це новий заголовок, а підводні камені — фейки та маніпуляції. Особливо гостро це відчувають різні покоління, адже їхні медіа-звички,...
Як технології змінюють медіа-ландшафт України
Від паперових газет до цифрових платформ Колись інформація поширювалася повільно, наче поштовий голуб, що летить крізь бурю. Сьогодні ж новини розлітаються миттєво, завдяки стрімкому розвитку цифрових технологій. Український медіа-ринок переживає трансформацію, де...
Unlocking the Potential of Online Casinos in Australia: A Strategic Guide
Did you know that the Australian online gambling market is projected to grow by over 10% annually in the next five years? This rapid expansion presents both exciting opportunities and significant challenges for players and operators alike. Understanding how to...
Les dessous méconnus des casinos en ligne : entre illusions et réalités
Les casinos en ligne, ces temples virtuels du hasard, fascinent autant qu'ils intriguent. Derrière les lumières clignotantes et les promesses de gains rapides, se cache un univers bien plus complexe qu'il n'y paraît. Naviguer dans cet océan de jeux numériques demande...
Unlocking the Secrets of Online Casino Success in Australia
Australia's online casino market has grown exponentially over recent years, offering players a vast array of gaming options and opportunities to win big. Navigating this vibrant landscape requires more than luck; it demands knowledge, strategy, and access to reliable...
Exploring Boo Casino: A Closer Look Beyond the Surface
When you first hear about Boo Casino, you might imagine a ghostly haunt of endless jackpots and spectral spins. But before you get carried away with visions of easy wins, it’s worth peeling back the curtain to see what’s really going on behind the scenes. Online...
Découvrez l’univers captivant des casinos en ligne en France
Le monde des casinos en ligne ne cesse de se développer, offrant aux joueurs français une expérience de jeu innovante et accessible. Grâce à la technologie et à une régulation adaptée, les plateformes de jeux virtuels proposent désormais une multitude d'options pour...
Exploring the Evolution of Online Pokies: A Comprehensive Guide
Did you know that the online pokies industry has grown exponentially over the past decade, captivating millions of players worldwide? This surge is not just a trend but a reflection of technological advancements and changing player preferences. As digital platforms...
Exploring the Dynamics of Online Slots: More Than Just Spinning Reels
When you think about online slots, the image of flashing lights and spinning reels might be the first thing that pops into your head. Yet, beneath the surface of these digital fruit machines lies a complex world of algorithms, odds, and player psychology. The online...
Unlocking the Potential of Online Casinos: A Deep Dive into Neospin
Did you know that the global online gambling market is projected to exceed $127 billion by 2027? This explosive growth is driven by innovative platforms and user-centric designs that redefine how players engage with casino games. Among these platforms, neospin stands...
Unlocking the Potential of Online Casinos: A Strategic Guide for Australian Players
Did you know that the Australian online gambling market is projected to grow by over 10% annually? This surge highlights the increasing popularity and accessibility of digital casinos. For players seeking to maximize their gaming experience while minimizing risks,...
Les Secrets pour Maximiser vos Gains sur les Casinos en Ligne Français
Le monde des casinos en ligne ne cesse de se développer en France, offrant aux joueurs une multitude d'options pour tenter leur chance et décrocher des gains intéressants. Cependant, réussir à optimiser ses chances de victoire demande plus que de la simple chance. Il...
Stay Casino Login Australia: Your Gateway to Premier Online Gaming
In the rapidly evolving world of online casinos, Stay Casino has emerged as a top choice for Australian players seeking a secure, entertaining, and rewarding gaming experience. Whether you are a seasoned gambler or a newcomer, understanding how to access and navigate...
Unraveling the Allure of Online Slots: A Closer Look at Dragon Slots
When it comes to online slots, the landscape is as crowded as a Vegas casino on New Year's Eve. Yet, some platforms manage to carve out a niche that’s more than just smoke and mirrors. Dragon Slots, for instance, has been making waves, but not necessarily for the...
Discover the Exciting World of Online Casino Games in Australia
Online casino gaming has become one of the most popular forms of entertainment in Australia. With the rise of digital platforms, players can now enjoy a vast selection of casino games from the comfort of their own homes. Whether you are a fan of pokies, table games,...
Unlocking the Potential of Online Casino Gaming: A Deep Dive into Woospin Casino Slots
Did you know that the global online gambling market is projected to surpass $127 billion by 2027? This explosive growth is largely driven by innovative slot games that captivate players worldwide. Among these, woospin casino slots have emerged as a standout choice for...
Megapariar: Análisis Completo de una Plataforma de Apuestas en Crecimiento
En el dinámico mundo de las apuestas en línea, encontrar una plataforma confiable y atractiva puede ser todo un desafío. Megapariar se ha posicionado rápidamente como una opción destacada para usuarios que buscan variedad, seguridad y buenas promociones. ¿Qué hace que...
Exploring the Sweet Surprises of Online Casino Platforms
Online gambling has evolved into a sprawling digital playground where players seek more than just spinning reels or card hands. Among the myriad options, a big candy casino stands out not just for its name but for the curious blend of features it offers. While the...
Exploring the Landscape of Online Casinos in Australia
Australian online casinos have been stirring up the scene like a roo in a top hat—unexpected and a bit cheeky. While the market might seem saturated with flashy promises and neon lights, peeling back the layers reveals a more nuanced picture. Players often find...
Exploring the Landscape of Online Casinos in Australia
Australian online casinos have carved out a niche that’s as intriguing as a high-stakes poker game at a smoky backroom table. While the market is flooded with options, not every platform delivers the experience players expect. Navigating this digital jungle requires...
DonBet : Une Analyse Complète de la Nouvelle Référence des Paris en Ligne
Le marché des paris sportifs en ligne connaît une croissance exponentielle, avec une concurrence féroce entre les plateformes. Pourtant, certaines se démarquent par leur interface intuitive, leurs offres attractives et leur sécurité irréprochable. DonBet s’impose...
Discover the Ultimate Online Betting Experience with Jet4Bet
In the fast-paced world of online gaming, finding a reliable and exciting platform is essential for both beginners and seasoned players. Jet4Bet stands out as a premier destination for online betting enthusiasts, offering a comprehensive range of games, competitive...
Exploring the Dynamics of Online Casino Platforms
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...
Vegas Plus : Découvrez l’Expérience Ultime du Casino en Ligne
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...
Gratorama : Une Analyse Complète de la Plateforme de Jeux en Ligne
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 qu'est-ce qui fait son succès...
Lorem ipsum dolor sit amet
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....
Install Kubernetes in CentOS
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
Partitions held by a table
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)...
Table in Quiesce Mode
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...
Database Up Time
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...
Database Size and Table Sizes
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...
Count Rows When Loading
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...
IBM Provided Utility Scripts for Db2
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...
Utility Scripts for pureScale
Instead of typing too much, it is always better to have some utility scripts that makes life easier. Before doing any debugging, I always like to test the time on all servers to make sure that it is same. In past, I have spent hours to find the root cause of a problem and later to discover that the server time was off on all machines. So, using runall scripts comes very handy. Sameway, when I am building a golden image for either DB2 BLU DPF or pureScale, I need to copy same script from one server to all others, runscp scripts comes very handy.
Big Data Hype and Reality
C Mohan talk has been given as a keynote during the BIRTE 2016 conference held in conjunction with VLDB 2016 and in the ACM SIGMOD China Workshop held in conjunction with the 33rd Chinese National Database Conference (NDBC 2016).
Db2 pureScale netname does not exist
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...
New Era in Distributed Computing with Blockchains and Databases
A new era is emerging in the world of distributed computing with the growing popularity of blockchains (shared, replicated and distributed ledgers) and the associated databases as a way of integrating inter-organizational work. Originally, the concept of a distributed ledger was invented as the underlying technology of the cryptocurrency Bitcoin.
IBM Claims Big Breakthrough in Deep Learning
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...
DB2 Backup Tuning
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:...
DB2 pureScale Utility Scripts
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...
Data Server Manager 2.1.4
DSM new release announced on June 22, 2017
DB2 11.1 BLU with DPF Monitoring scripts
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...
db2haicu disable / enable and scripting
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 command...
DB2 pureScale – No Product License found
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 avail...
DB2 pureScale instance creation hangs after GPFS
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 23s!...
DB2 pureScale Health Check
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 physician...
How to detect log full condition
I have seen working with hundreds of customers a chronic LOG FULL condition and the shortcut people use is to increase the LOGPRIMARY and LOGSECOND. This solution works well for a single unit of work that can not fit into the total log space available. So, first let's...
Kernel upgrade and impact on pureScale
In Linux environment, it is a common practice to upgrade the kernel for security patches, vulnerability fixes etc. And if you are running a DB2 pureScale environment, it is likely that you are going to break the GPFS GPL as soon as you upgrade the kernel and this will...
GPFS Disk Cleanup
During pureScale instance creation, you might run into instance creation failed condition. Under some circumstances, it is possible that db2icrt does not perform a proper clean-up for GPFS and it may fail next time complaining that the disk is already a GPFS disk....
SQL fishing using WLM
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...
Automatic Client Reroute – Templates
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...
Rebuild TSA Resources in HADR Environment
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...
DB2 11.1 Rebuild TSA Resources
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...
DB2 pureScale Install Problem Determination
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:...
DB2 purescale Install GPL Error
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...
db2start add member fails
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...
Install Dropline Neu! Icons in CentOS 7.2
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...
Drop a member in DB2 pureScale by Force
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...
Enable Fast I/O Fencing Scipt for Linux
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...
Find out Slot number of PCI Card
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...
WWNN and WWPN of FC Card
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 :...
DB2 pureScale rebuild TSA Resources
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...
TCPIP Tuning at VIOS and AIX
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...
Avoid Tie Breaker Disk
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...
RSCT Commands – Cheat Sheet
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...
Clear Reservations from Tie-Breaker
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...
Tie-Breaker Disk for HADR or pureScale
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...
GPFS, RSCT and TSA Version Info.
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...
DB2 pureScale – shared disks using SCSI-3 PR
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
Clean-up pureScale
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...
DB2 pureScale – Online Rolling update
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...
DB2 Table Spaces – When to use File System Caching
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...
SQL6030N START or STOP DATABASE MANAGER failed. Reason code “38”
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...
X Display Issues as sudo
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...
DB2 10.5 pureScale TSA Recovery
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 and WLM
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...
Change mount point in pureScale Cluster
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...
Monitor Crash Recovery Script
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...
How to find out LOG HOG
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...
Change IP address in pureScale cluster
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...
Google God
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...
Client Affinity and Automatic Client Reroute for Java
Let us understand client affinity and automatic client reroute. For example: We have 3 members in a DB2 pureScale cluster and I have one application that connects to one member from any application server. The same application connects to the second member from...
Test Automatic Client Reroute
Wouldn't it be nice to do some Java testing without writing a line of code? For the following to work, it is necessary that db2jcc.jar and db2jcc_license_cu.jar are on the CLASSPATH. If you login as db2 instance user, these jar files should be in the CLASSPATH...
DB2 pureScale GPFS Error
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...
Validation of 10GbE in DB2 pureScale 10.5
Additional Packages After installation of basic Redhat 6.2 OS, the following additional components are required. # yum install perftest # yum install sysfsutils # yum install kernel-devel # yum install compat-libstdc++ # yum install tcl # yum install tk # yum install...