var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
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.
Have you tried COLLECTION option of the BIND command?
and use qualifier option as well
Thanks mark.b and dav1mo.
That solved my problem!
Tags for this Thread