User Profile

prasanna2100 · Mar 20 '08, 01:48 PM

Hi Bernd,

Iam trying to execute export and load from shell script

Code:

##################################################
# Connect to OMDSTG
##################################################

db2 connect to ${OMD_DB} user ${OMD_USER} using ${OMD_PASS} >> ${LOCAL_LOG_FILE}
if [ $? -ne 0 ]
then
   echo "`date +%Y-%m-%d_%H:%M:%S`:ERROR: DB2 Connect to ${OMD_DB}

...

prasanna2100 · Mar 20 '08, 01:36 PM

Hi,
i tried export to dumpedtable.ixf of ixf select '*' from omdstgd.omd_d_e vent_track

it worked .
but now the
load is troubling

SQL3025N A parameter specifying a filename or path is not valid.

2008-03-20_09:34:35:ERR OR: load from dumpedtable.ixf of ixf insert into OMDD.OMD_D_EVEN T_TRACK - Failed....

prasanna2100 · Mar 20 '08, 01:28 PM

Hi Bernd,

I tried
export to dumpedtable.ixf of ixf select \* from omdstgd.omd_d_e vent_track

and the error iam getting is
SQL3022N An SQL error "-7" occurred while processing the SELECT string in the
Action String parameter.

SQL0007N The character "\" following "select " is not valid. SQLSTATE=42601...

prasanna2100 · Mar 19 '08, 11:33 PM

Hi ,
When i Use the command "export to dumpedtable.ixf of ixf select * from ${SRC_SCHEMA}.$ {TABLE_NAME}"

iam getting an error message

"SQL3022N An SQL error "-104" occurred while processing the SELECT string in
the Action String parameter."

prasanna2100 · Mar 14 '08, 02:02 PM

the DB2 which we r using is version 9.1

prasanna2100 · Mar 13 '08, 11:56 PM

Source and Target are in same servers,its in UNIX environment

User Profile

Profile Sidebar

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

Leave a comment:

DB2 Bulk Load