Results 1 to 4 of 4
  1. #1
    Join Date
    Feb 2009
    Posts
    7

    Unanswered: Change PKGSCHEMA in SYSCAT.PACKAGES table.

    Is there any way to change PKGSCHEMA for a package in SYSCAT.PACKAGES table?

    Here is what I am trying to do :

    I have two environments(server) : ST and ET.
    I am compiling a cobol program ABC on ST with user STuser, and then transferring the ABC.bnd file and executable ABC to ET.

    On ET, I do not have the liberty to compile the program.
    So, I can just bind the program on ET with ETuser.
    This binding results in the PKGSHEMA as STUser, with owner ETuser in SYSCAT.PACKAGE table.

    The program execute fine on ET , but while rebinding it gives a problem : "Package ETuser.ABC not found"

    I can rebind the program on ET using db2 rebind STuser.ABC, but it does not look good as I am using ST package on ET.

    Is there any way to change PKGSCHEMA? using some db2 utilities?

    Any help will be appreciated.

    Thanks,
    Ashish S

  2. #2
    Join Date
    Jul 2013
    Location
    Moscow, Russia
    Posts
    666
    Provided Answers: 55
    Hi Ashish,

    Have you tried COLLECTION option of the BIND command?
    Regards,
    Mark.

  3. #3
    Join Date
    Dec 2007
    Location
    Richmond, VA
    Posts
    1,328
    Provided Answers: 5
    and use qualifier option as well

  4. #4
    Join Date
    Feb 2009
    Posts
    7

    Thanks

    Thanks mark.b and dav1mo.

    That solved my problem!

Tags for this Thread

Posting Permissions

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