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

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.

By default, you get 3 versions of the package. But for very complex queries, addtional versions are needed.