Hi all DBAs
I want if anyone of u have time to declare what are the functions of these packages???!!! and what are they doing????
1-SQLLF000
2-SYSSH200
3-SQLC2D01
thanks in advance....

Do they have NULLID schema??If so they are packages used by db2(system packages) or might be packages for dynamic sql

Looks like these packages should be binded to the server when the server needs to talk to a different version of db2 client. I am not sure about the functions in those packages.

This link might be useful to you:
http://www-128.ibm.com/developerwork...ex.html#N10CC4

Hi All,

I am working in a bank which has several independent db2 databases running in different cities and a J2EE application at front end. For increasing performance I have planned to run the reorg table, runstat and rebind package command on these dbs.

My Question is

(1) Do we also need to bind these db2 (system packages) having NULL schema after running reorg and runstat command.
(2) Please also tell, is there any side effect of running reorg table and runstats command on these dbs or Should I use them without any worries.

simply have a look at the content of those PACKAGES:

SQLLF000:
DECLARE SQLCUR1 CURSOR FOR S1
DECLARE SQLCUR2 CURSOR FOR S2
...
DECLARE SQLCUR64 CURSOR FOR S64

SYSSH200:
DECLARE SQL_CURSH200C1 CURSOR WITH HOLD FOR s1
...
DECLARE SQL_CURSH200C64 CURSOR WITH HOLD FOR s64

SQLC2D01:
DECLARE SQLCUR1 CURSOR FOR S1
...
DECLARE SQLCUR100 CURSOR FOR S100
DECLARE SQLCUR101 CURSOR WITH HOLD FOR S101
...
DECLARE SQLCUR200 CURSOR WITH HOLD FOR S200
DECLARE SQLCUR201 CURSOR FOR S201
DECLARE SQLCUR202 CURSOR FOR S202


as there is no other static sql in it, a REBIND will not have any effect regarding the performance.

* edit *

Thanks umayer,

Though I couldn't understand any thing . I am not that much experienced.

What I asked was that If I run REORG COMMAND using INDEXES and then I run RUNSTAS COMMAND and then I run REBIND PACKAGES command on all the tables and packages, would it have any side effects besides performance, like our J2EE application not getting connected or tables do not exist or any other un-natural behavior.

Hope you understand what I mean to say