Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2005
    Posts
    102

    Unanswered: db2 bind command

    Hi All,

    we were running a huge SQL on our production every night to update some data. This query was failing almost everytime, after opening a PMR with IBM they send us the reply in 4 steps. Here are they:

    1. Open a db2 command line window on your db2 server (Start -> run -> db2cmd)
    2. change to the SQLLIB\bnd directory (cd \sqllib\bnd)
    3. connect to the sample database (db2 connect to sample)
    4. enter the following command: db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG <number>

    where <number> is any integer greater than 3.

    Can somebody help me in understanding the what this db2 bind command is doing?

    Thanks in advance

    Anks

  2. #2
    Join Date
    Jul 2005
    Location
    Irvine, CA
    Posts
    23
    Bind is a fundamental part of DB2. It is covered in the first DB2 fundamentals course and should be part of your daily study.

    See the DB2 V8 Command Reference Manual - Pages 211 through 230. Or better yet, search Google for DB2 BIND.

  3. #3
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    Quote Originally Posted by anksagr
    Hi All,

    we were running a huge SQL on our production every night to update some data. This query was failing almost everytime, after opening a PMR with IBM they send us the reply in 4 steps. Here are they:

    1. Open a db2 command line window on your db2 server (Start -> run -> db2cmd)
    2. change to the SQLLIB\bnd directory (cd \sqllib\bnd)
    3. connect to the sample database (db2 connect to sample)
    4. enter the following command: db2 bind @db2cli.lst blocking all grant public sqlerror continue CLIPKG <number>

    where <number> is any integer greater than 3.

    Can somebody help me in understanding the what this db2 bind command is doing?

    Thanks in advance

    Anks
    By default, you get 3 versions of the package. But for very complex queries, addtional versions are needed.
    M. A. Feldman
    IBM Certified DBA on DB2 for Linux, UNIX, and Windows
    IBM Certified DBA on DB2 for z/OS and OS/390

Posting Permissions

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