Results 1 to 11 of 11

Thread: UDB Fixpak

  1. #1
    Join Date
    Sep 2002
    Posts
    456

    Unanswered: UDB Fixpak

    Hi Guys,

    What is the best way to find out in UDB V7.x about the fixpak you are currently on, or it has to do with the interepretation of the db2level command?

    dollar

  2. #2
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: UDB Fixpak

    I'm afraid, for v7 , db2level command is not very informative to give the fixpack level

    In v8, db2level displays the fixpack number in a 'human-readable' format

    Cheers

    sathyaram

    Originally posted by dollar489
    Hi Guys,

    What is the best way to find out in UDB V7.x about the fixpak you are currently on, or it has to do with the interepretation of the db2level command?

    dollar

  3. #3
    Join Date
    Sep 2002
    Posts
    456

    Re: UDB Fixpak

    Thanks, I am also evaluating V8 and it's much easeir to use. But my problem still remains the same....

    dollar

    Originally posted by sathyaram_s
    I'm afraid, for v7 , db2level command is not very informative to give the fixpack level

    In v8, db2level displays the fixpack number in a 'human-readable' format

    Cheers

    sathyaram

  4. #4
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: UDB Fixpak

    I have a feeling I haven't understood your question ... Please can you elaborate ...

    Cheers


    Sathyaram


    Originally posted by dollar489
    Thanks, I am also evaluating V8 and it's much easeir to use. But my problem still remains the same....

    dollar

  5. #5
    Join Date
    Sep 2002
    Posts
    456

    Re: UDB Fixpak

    Hi, I just wanted to know on V7 which fixpack I am currently on. I know I can ask our OS group about which fixpak's they have applied but is there any easier way for a DBA to accomplish that.
    Hope I am bit clearer now.

    dollar

    Originally posted by sathyaram_s
    I have a feeling I haven't understood your question ... Please can you elaborate ...

    Cheers


    Sathyaram

  6. #6
    Join Date
    Aug 2001
    Location
    UK
    Posts
    4,650

    Re: UDB Fixpak

    I do a db2level command and then cross-reference

    http://www-3.ibm.com/cgi-bin/db2www/...oad.d2w/report

    to know the fixpack ...

    The output of db2level command on V8 explicitly mentions the fixpack number

    Cheers
    Sathyaran

    Originally posted by dollar489
    Hi, I just wanted to know on V7 which fixpack I am currently on. I know I can ask our OS group about which fixpak's they have applied but is there any easier way for a DBA to accomplish that.
    Hope I am bit clearer now.

    dollar

  7. #7
    Join Date
    Sep 2002
    Posts
    456

    Re: UDB Fixpak

    Thanks....
    I guess I do need to involve our OS group to better co-ordinate this effort.

    dollar

    Originally posted by sathyaram_s
    I do a db2level command and then cross-reference

    http://www-3.ibm.com/cgi-bin/db2www/...oad.d2w/report

    to know the fixpack ...

    The output of db2level command on V8 explicitly mentions the fixpack number

    Cheers
    Sathyaran

  8. #8
    Join Date
    Nov 2002
    Location
    Rio de Janeiro - Brazil
    Posts
    78

    Re: UDB Fixpak

    I don´t know how this might help you, but still it´s worth a shot:

    If you´re running DB2 under UNIX, you can issue an 'lslpp -al "db2_07*"'|more
    and see the filesets and their levels, with that you can see wich was applied last and find out in which FP you are.
    For example:
    FileSets : db2_07_01.client
    Level | State | Description
    7.1.0.0 COMMITTED Client Application Enabler
    7.1.0.41 COMMITTED Client Application Enabler
    7.1.0.60 COMMITTED Client Application Enabler
    7.1.0.68 COMMITTED Client Application Enabler

    The last level ins 7.1.0.68 which is the signature for FP7

    HTH,
    Fernando

    Originally posted by dollar489
    Thanks....
    I guess I do need to involve our OS group to better co-ordinate this effort.

    dollar

  9. #9
    Join Date
    Sep 2002
    Posts
    456

    Re: UDB Fixpak

    Thanks, that was a good help.

    dollar

    Originally posted by F.OHANA
    I don´t know how this might help you, but still it´s worth a shot:

    If you´re running DB2 under UNIX, you can issue an 'lslpp -al "db2_07*"'|more
    and see the filesets and their levels, with that you can see wich was applied last and find out in which FP you are.
    For example:
    FileSets : db2_07_01.client
    Level | State | Description
    7.1.0.0 COMMITTED Client Application Enabler
    7.1.0.41 COMMITTED Client Application Enabler
    7.1.0.60 COMMITTED Client Application Enabler
    7.1.0.68 COMMITTED Client Application Enabler

    The last level ins 7.1.0.68 which is the signature for FP7

    HTH,
    Fernando

  10. #10
    Join Date
    Feb 2004
    Posts
    1

    Smile mismatch in lslpp and db2level

    Hi,
    I am little bit confused as my system shows different levels in AIX system with UDBv7.1
    in db2level it shows as
    "DB21085I Instance "aspinst1" uses DB2 code release "SQL07024" with level identifier "03050105" and informational tokens "DB2 v7.1.0.60", "s020313" and "U481406"."

    and in lslpp -l it shows as
    db2_07_01.client 7.1.1.60 COMMITTED Client Application Enabler db2_07_01.cnvucs 7.1.1.60 COMMITTED Code Page Conversion db2_07_01.conn 7.1.1.60 COMMITTED Connect

    now we know that 7.1.0.x is for 32bit and 7.1.1.x is for 64 bit.

    Hence the confusion......
    now at present db2 is what level? is db2level or lslpp right?
    my doubt is that maybe my previous dba might have forgotten the db2iupdt -w 64 option hence this is like that? what do u all think?

    Thanks ,
    Amit.

  11. #11
    Join Date
    Jan 2003
    Posts
    1,605
    Hi amitnair,

    It is little bit easyer that it looks. For db2 version 7:
    1. db2level gives you "DB2 v7.1.0.60" info.
    2. goto page download fixpack page and look at Signature column. Then read the fixpack number in Number column.

    So amitnair, you have fixpack 6 installed.

    Hope this helps,
    Grofaty

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •