Unanswered: loading data with cli program (db2 v8.1)
I've got a C-Programm which is transforming data. This data (about 60.000.000 entries) is then loaded into a db2 database by using the CLI "Load" function. The programm is sequentiel, no fork() is called anywhere. (I buffer 40.000 values before starting load).
For small numbers (about 100.000 entries) everything works fine. But when I try to load the total amount of data, my programm exists with:
SQL2044N An error occurred while accessing a message queue. Reason code: "1”
SQL2044N An error occurred while accessing a message queue. Reason code: "3”
Why is db2 using so many message queues? (I've already increased the max. number of message queues.)
My understanding in programming is:when i call a subroutine, my mainprogram is waiting until the subroutine finished. So "load" should be finished when i start to load a new block of data, and the number of used message queues should be quite constant.