How to Find If Backup Image is consuming RAM
By Pass File System Caching by DB2SET DB2_BACKUP_USE_DIO=ON
DB2 BACKUP DIO
Happy Learning & Sharing
Information Management India - Bloggers Guild
HarishPathangay 270002WA13 199 Visits
HarishPathangay 270002WA13 193 Visits
HarishPathangay 270002WA13 510 Visits
HarishPathangay 270002WA13 331 Visits
Brinda_Krish 270003Y3MB 340 Visits
The 3rd KIDUG DB2 event is happening this November, 15 from 9:30 am to 3:30 pm. No registration fee and open to IBMers as well as non-IBMers.
When : 15th Nov 2014 (Saturday) from 9:30 Am to 3:30 PM
Venue : Techno India Campus,Salt Lake,Sector V, Kolkata, India
Who can join : Anyone who is having interest in DB2 or working on DB2
How to book your seat : Send a mail from your official mail id to firstname.lastname@example.org with subject line "I will attend"
Leading Speakers from : Capgemini, MJunction, TCS, IBM
Few lucky KIDUG participant will be able to WIN FREE DB2 Books of worth US$ 17.95 through Lucky draw
kprageet 270000DK0B 318 Visits
DB2 image have product specification file in the CD image. This file contains few basic details about the DB2 image that would be useful for customer.
This product file is located in the following directory in DB2 image :
[root directory on the CD /server]# ls
db2 db2checkCOL_readme.txt db2checkCOL.tar.gz db2ckupgrade db2_deinstall db2_install db2ls db2prereqcheck db2setup ibm_im installFixPack
[image root directory on the CD / server] # cd db2
[image root directory on the CD/ server / db2]# ls
common license linuxamd64 samples spec
From DB2 version 10.5 on wards there are few new information added to this file which are specific to pureScale on Linux and AIX platform. These information are really useful and helpful for the customer and DBA to take a decision on the method of applying fixpack. Let us look at the meaning of each row and how it will be helpful in this tutorial.
Looking at the image, you can decide what type fixpack update (online or offline ) is possible when you want to apply the image in the DB2 fixpack CD. This would help to decide on whether you need a maintenance window to take an outage of the cluster or it does not need an outage to your pureScale instance at all.
The content of the file looks like :
[image root directory on CD /server / db2]# cat spec
From the above list,
DB2 text search indexing is a resource consuming task and it takes times based on number of documents to be indexed, the type and size of the document etc. In this blog, I would like to briefly explain how we can check the progress of ongoing DB2 Text search index updates.
db2ts "CREATE INDEX MYSCHEMA.MYTITLEIDX FOR TEXT ON books(title)"
And to populate the text search indexes:
To check the progress of the above index update command, we can check the number of documents indexed until now using the adminTool for text search. Refer to http://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ts.doc/doc/r0052950.html?lang=en for detail explanation on adminTool.
./adminTool.sh status -configPath ~/sqllib/db2tss/config -collectionName lappanna_TSDB_TS435205_0000
If there was any ongoing index updates, then running the same command again after some time will show the updated number of documents.
./adminTool.sh status -configPath ~/sqllib/db2tss/config -collectionName lappanna_TSDB_TS435205_0000
The total number of documents that has to be indexed can be found by checking the number of rows in base table (in this case it is table books) on which index is created or if it is incremental index update that is in progress, then users can check the number of rows in the staging table to get the total number of documents that should be there in collection altogether.
Note: We can get the collection name for any text search index, by querying the SYSIBMTS.TSCOLLECTIONNAMES administrative view.
db2 "select COLLECTIONNAME from SYSIBMTS.TSCOLLECTIONNAMES where INDNAME='MYSCHEMA' and INDSCHEMA='MYTITLEIDX'"
Thus we can check the progress of DB2 Text Search index updates by comparing the number of rows in base table(on which index is created) for initial updates or in staging table for incremental updates with the number of documents in collection got by adminTool.
./adminTool.sh status -configPath ~/sqllib/db2tss/config
db2 "SELECT EVENTVIEWSCHEMA, EVENTVIEWNAME FROM SYSIBMTS.TSINDEXES WHERE INDSCHEMA='MYSCHEMA' AND INDNAME='MYTITLEIDX'"
Refer to https://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.admin.ts.doc/doc/r_eventview.html for more information on DB2 text search event view.
We are all seeing it ! The databases are getting bigger and bigger and the queries are becoming more and more complex. Under these circumstances, if a particular SQL query does not perform well then it is very critical to find and remove the performance bottleneck as soon as possible. In this blog, I would like to share a systematic step-by-step method to tune the given query.
Prerequisite: We need to know the most important resources required for query processing.
Step 1: Monitor the actual resources consumed while DB2 was processing the given query.
MdYaseen 270001TE2X 306 Visits
Payload method is one of the install method which is used by advanced customer, wherein you don't install DB2 using commands instead just uncompress the binaries. Below are the steps do create pureScale instance using the payload method
1)Download and install DB2
HarishPathangay 270002WA13 974 Visits
HarishPathangay 270002WA13 835 Visits
NivedithaRabakavi 2700042KSM 440 Visits
Verifying the system & other requirements before installing a software is very important rather going ahead with Installation and failing at various levels.
db2prereqcheck is one such tool developed to verify the prerequisites on the systems before attempting a DB2 installation.
This would be a best practice and could be applicable across various products/technologies .
db2prereqcheck command without any options checks for prerequisites for all versions of DB2 mentioned in the xml file.
db2prereqcheck -? gives the help and different options for the command.
Few Examples of running db2prereqcheck command:
1. To check whether the system meets the basic pureScale prerequisites for a specific DB2 version, issue the following command(Linux/Unix):
2. To check whether the system meets the comprehensive pureScale prerequisites for a specific type of network configuration (Linux operating systems only) and for a specific DB2 version, issue the following command (Linux/Unix)::
3. To redirect the db2prereqchekc output use -o option as below:
4. To get the detailed debug version of output from db2prereqcheck use -d option.
db2prereqcheck tool on Windows:
On windows the db2prereqcheck tool will verify if a particular DB2 release and version is supported on the OS on which it is run.
There is a xml file named DB2prereqs.xml maintained in the image location which stores the DB2 release and version information.
Usage:From 10.5fp4 onwards there is no prerequisites required to run db2prereqcheck tool on Windows.
User can just download the image and run db2prereqcheck from the image directly.
db2prereqcheck tool for Linux/UNIX:
On Linux/UNIX db2prereqcheck checks for prerequisites to install DB2 with no pureScale feature and with pureScale feature(on Linux and AIX only).
Common validation includes OS version, kernel version, general libraries. PureScale validations include space, ksh,ntp, Adapaters, Java etc.
Usage: db2prereqcheck command can be run from the image/server location.
Common errors\warnings with db2prereqcheck and the solutions.
1. Prior to V10.5 Fixpack4, db2prereqcheck was dependent on the Microsoft VC++ redistributables on the machine.
If the VC++ redistibutables are not present on the machine db2prereqcheck execution fails with error as below.
For the DB2 version 10.1 product, the db2prereqcheck tool displays "Could not load the resource library C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\\db2istring_v101.dll" error when the MSVCR100.dll file is missing in the system.
For the DB2 version 10.5 product, the db2prereqcheck tool displays "Could not load the resource library C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\\db2istring_v105.dll" error when the MSVCR110.dll file is missing in the system.
Resolution is to install the below packages and launch db2prereqcheck from image location again.
For the DB2 V10.1 product, install Microsoft Visual C++ redistributable package for VS2010, which contains the MSVCR100.dll file.
For the DB2 V10.5 product, install Microsoft Visual C++ redistributable package for VS2012, which contains the MSVCR110.dll file.
1. During the DB2 installation (Linux and AIX) db2prereqcheck will be called multiple times and the output of each call will be appended to the /tmp/db2prereqcheckOut.log file.
Resolution : The last entry has to be considered to determine the exact failure.
2. If there are any major errors with db2prerqcheck run during installation , "-f sysreq" option can be used to skip the hard fail and continue with the installation.
Post installation the errors can be rectified.
3. If db2prereqcheck fails to execute on remote hosts with -hl option when run on IIH , Check if the ssh and scp copy command works properly on the remote host.
4. A 32 bit libpam.so is present on the machine and still db2prereqcheck fails with Waring that libpam.so not found upon setting a particular locale.
Resolution is to manually verify if libpam.so is present and ignore the Warning message. The issue is fixed in later fixpacks.
HarishPathangay 270002WA13 459 Visits
HarishPathangay 270002WA13 638 Visits
Comparison between DB2 Universal and DB2 Server_t images on v10.5 Fix Central
Introduction to IBM Support Fix Central
Below is the homepage for IBM Support Fix Central which provides fixes and updates for all DB2 versions and releases.
Step 1: Go to Select product tab and select the required product, version and platform for which you are looking for fixes and updates. Press continue.
Step 2. If you are looking for all the available fix pack updates then select “Browse for fixes' Else select the relevant option for specific APAR or fix Ids.
Step 3. Below page shows all the available Fix Pack downloadable for DB2 v10.5 fix pack 4 for linuxamd64 platform. Select the required image and download.
Comparison between Universal and Server_t image
Universal image: DB2-linuxx64-universal_fixpack-10.5.0.4-FP004
Server_t image: DB2-linuxx64-server_t-10.5.0.4-FP004