Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2013
    Posts
    33

    Unanswered: where DB2 luw stores CLIPKG value?

    Before I run the below command, I want to check what was my earlier clipkg value that I had..I remember running it with clipkg 19.. I could check for the list of packages in the syscat.packages and can come to a conclusion based on the last package name..but I am looking at a place where the clipkg value "19" was set for DB2 to know that is the max value.


    db2 "bind @db2cli.lst clipkg 30 blocking all grant public "

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    The value you are looking for is here:

    Code:
    select max(substr(pkgname, 7, 2)) + 1
    from syscat.packages
    where pkgschema='NULLID' and pkgname like 'SYSLH2%'
    Regards,
    Mark.

Posting Permissions

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