Help with db2Load API (COPY= YES USE TSM)

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Vivek - 30 Jan 2008 11:33 GMT

Hi,

Ive written a test program for loading data into a table using the
db2Load api. It works fine except when i specify COPY = YES USE TSM.
Ive set the aforementioned attribute in the api by the following line
of code:

if(useTsm == 'Y' || useTsm == 'y')
{
loadParms.piCopyTargetList = &copyMediaList;
loadParms.piCopyTargetList->media_type = SQLU_ADSM_MEDIA;
loadParms.piCopyTargetList->sessions = 1;
}

On running the program i get the following error:

SQL2032N The "copy_flag" parameter is not valid

What might be the problem ?

Reply to this Message

Vivek - 31 Jan 2008 05:33 GMT

> Hi,
>
[quoted text clipped - 15 lines]
>
> What might be the problem ?

I found the problem. In order to create a copy the
"loadInfoIn.iNonrecoverable" parameter should be set to
SQLU_RECOVERABLE_LOAD instead of SQLU_NON_RECOVERABLE_LOAD

Reply to this Message