How to Force Query to use IXSCAN over a TBSCAN
Define Optimization Profile with guidelines accordingly.
Information Management India - Bloggers Guild
HarishPathangay 270002WA13 132 Visits
HarishPathangay 270002WA13 134 Visits
HarishPathangay 270002WA13 484 Visits
HarishPathangay 270002WA13 412 Visits
HarishPathangay 270002WA13 153 Visits
HarishPathangay 270002WA13 142 Visits
HarishPathangay 270002WA13 466 Visits
HarishPathangay 270002WA13 278 Visits
Brinda_Krish 270003Y3MB 299 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 262 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,