Prev: zOS equivalent to nicknames
Next: DB2 processes haning around ...
From: Richard on 7 May 2010 13:08
I was told to run this command to fix an issue we're having in a dev
environment.

db2 connect to my-db
db2 bind @db2cli.lst blocking all grant public sqlerror continue
CLIPKG 5

If I backup my-db in this enviroment and restore it in another
environment where the
bind has not been done, do I need to run the bind in the new
environment, or does the
affect of the bind come over in the backup?

Thanks.
From: Ian on 7 May 2010 14:23
On 5/7/10 10:08 AM, Richard wrote:
> I was told to run this command to fix an issue we're having in a dev
> environment.
>
> db2 connect to my-db
> db2 bind @db2cli.lst blocking all grant public sqlerror continue
> CLIPKG 5
>
> If I backup my-db in this enviroment and restore it in another
> environment where the
> bind has not been done, do I need to run the bind in the new
> environment, or does the
> affect of the bind come over in the backup?
>
> Thanks.

Binding creates entries in SYSCAT.PACKAGES. So, yes, a
backup/restore will include all bound packages.

That said, it's usually a good idea to bind the CLI packages
(contained in db2cli.lst) and utility packages (contained in
db2ubind.lst) on the target system, just to ensure that you're
binding the correct code.



From: Richard on 7 May 2010 17:05

> Binding creates entries in SYSCAT.PACKAGES.  So, yes, a
> backup/restore will include all bound packages.
>
> That said, it's usually a good idea to bind the CLI packages
> (contained in db2cli.lst) and utility packages (contained in
> db2ubind.lst) on the target system, just to ensure that you're
> binding the correct code.

Thanks for the reply.

So if I do the binds again on the target, won't I end up with an
additional set of records
in syscat.packages? That is, 5 from the first bind in source
database, and then another
5 from the second bind on the target database (that was restored from
source backup)?

Should I be unbinding (however that's done) in the target before I run
the bind again?

Thanks, again. :-)

From: Helmut Tessarek on 8 May 2010 05:23
Hi Richard,

> So if I do the binds again on the target, won't I end up with an
> additional set of records
> in syscat.packages? That is, 5 from the first bind in source
> database, and then another
> 5 from the second bind on the target database (that was restored from
> source backup)?

No, the packages are overwritten, that is, if they have the same version
identifier and the same package name. The version identifier can be specified
by the VERSION keyword in the 'db2 prep' command.

This means, if you use the same bind files, the packages will be overwritten.

The CLIPKG keyword is used to change the number of possible statement handles
available to an CLI application.

> Should I be unbinding (however that's done) in the target before I run
> the bind again?

No, this is not necessary, since they are overwritten. The correct command for
deleting packages would be 'db2 drop package'.

--
Helmut K. C. Tessarek
DB2 Performance and Development

/*
Thou shalt not follow the NULL pointer for chaos and madness
await thee at its end.
*/
From: Richard on 8 May 2010 09:25
Thanks so much for the answers. :-)
 | 
Pages: 1
Prev: zOS equivalent to nicknames
Next: DB2 processes haning around ...