John,
Following packages are bound with RR by default and can have a serious impact on the
system (locking system catalog objects).
=================================================================
Package utility Description
=================================================================
1. db2ueiwi.bnd export - write out index structure for each
index found in sysibm.sysindexes (ixf)
2. db2uiici.bnd import - create indexes on import
3. db2uiict.bnd import - create table on import
4. db2uexpm.bnd export - export utility
5. db2uimpm.bnd import - import utility
6. db2urexp.bnd reorg - reorganize a table
7. db2clprr.bnd clp - command line processor
8. db2uimtb.bnd import - class implementations for import table
====================================================================
Regards,
Ajith
-----Original Message-----
From: John Lantz [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, March 28, 2001 9:08 AM
To: [EMAIL PROTECTED]
Subject: DB2EUG: rebinding export packages
Last year there was a discussion about using EXPORT's and getting around
the problem with it
taking locks on the table you are exporting. It was mentioned that you can REBIND the
packages
and remove the RR isolation level. I've never been able to figure out which packages
are associated
with the EXPORT utility.
Can anybody who has done this let me know which packages would need to be rebound?
Thanks in advance.
John Lantz
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
