Results 1 to 7 of 7
  1. #1
    Join Date
    Mar 2008
    Posts
    6

    Unanswered: what are the functions of these packages????!!!!

    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....

  2. #2
    Join Date
    Jan 2008
    Posts
    45
    Do they have NULLID schema??If so they are packages used by db2(system packages) or might be packages for dynamic sql

  3. #3
    Join Date
    Mar 2008
    Posts
    8
    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

  4. #4
    Join Date
    Mar 2008
    Posts
    7
    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.

  5. #5
    Join Date
    Dec 2005
    Posts
    273
    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.
    Last edited by umayer; 03-31-08 at 10:40.

  6. #6
    Join Date
    Dec 2005
    Posts
    273
    * edit *

  7. #7
    Join Date
    Mar 2008
    Posts
    7
    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

Posting Permissions

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