f



SQL3107W There is at least one warning message in the message file.

When I try to call db2move $todbname load from a shell script it will
give me this error in the log.  When I call it from the command line
using the exact same dataset it works perfectly.  Does anyone know
what might be causing that to occur?  Below is the .msg file.

Thanks for any help.  I really need to put this script to bed.  This
is the last hangup.

Regards
Eric

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
++
Script snippet:
#
# Import Data
#
cd $db2moveimpdir/$expdate - This is the directory that I extracted
the .ixf files into.
mv db2move.lst db2move.lst.orig - Copy the original db2move.lst so I
can SED it using the next line.
sed -e "/$fromdbuser/ s//$todbuser/g" db2move.lst.orig > db2move.lst

`db2move "$todbname" load` - Still in the directory I run the command
wait

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++
LOAD.out error:

*** Table "DB8INST1"."ALCO_LOGIN_SESSION":  ERROR 3107.  Check message
file tab359.msg!

***  SQL Warning!  SQLCODE is  3107

***  SQL3107W  There is at least one warning message in the message
file.

+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
+++

root@hopdb1 # more tab359.msg

SQL3104N  The Export utility is beginning to export data to file
"tab359.ixf".



SQL3105N  The Export utility has finished exporting "7" rows.



SQL3501W  The table space(s) in which the table resides will not be
placed in

backup pending state since forward recovery is disabled for the
database.



SQL3039W  The memory available to LOAD for DATA BUFFER prohibits full
LOAD

parallelism.  Load parallelism of "1" will be used



SQL3109N  The utility is beginning to load data from file

"/backups/eldtest/dba/db2import/db2move/20071015/tab359.ixf".



SQL3500W  The utility is beginning the "LOAD" phase at time
"10-29-2007

07:40:53.079771".



SQL3150N  The H record in the PC/IXF file has product "DB2    02.00",
date

"20071015", and time "084357".



SQL3153N  The T record in the PC/IXF file has name "tab359.ixf",
qualifier "",

and source "            ".



SQL3168W  The PC/IXF column specified to be loaded into database
column "5" is

not compatible with the database column.  Nulls will be inserted.



SQL3519W  Begin Load Consistency Point. Input record count = "0".



SQL3520W  Load Consistency Point was successful.



SQL3110N  The utility has completed processing.  "7" rows were read
from the

input file.



SQL3519W  Begin Load Consistency Point. Input record count = "7".



SQL3520W  Load Consistency Point was successful.



SQL3515W  The utility has finished the "LOAD" phase at time
"10-29-2007

07:40:53.253147".



SQL3500W  The utility is beginning the "BUILD" phase at time
"10-29-2007

07:40:53.300471".



SQL3213I  The indexing mode is "REBUILD".



SQL3515W  The utility has finished the "BUILD" phase at time
"10-29-2007

07:40:53.529893".



SQL3107W  There is at least one warning message in the message file.

0
EricDeWerth
10/31/2007 3:59:32 PM
comp.databases.ibm-db2 12448 articles. 3 followers. arunrocks (9) is leader. Post Follow

2 Replies
8563 Views

Similar Articles

[PageSpeed] 1

On Oct 31, 4:59 pm, EricDeWerth <Eric.DeWe...@gmail.com> wrote:
> When I try to call db2move $todbname load from a shell script it will
> give me this error in the log.  When I call it from the command line
> using the exact same dataset it works perfectly.  Does anyone know
> what might be causing that to occur?  Below is the .msg file.
>
> Thanks for any help.  I really need to put this script to bed.  This
> is the last hangup.
>
> Regards
> Eric
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> ++
> Script snippet:
> #
> # Import Data
> #
> cd $db2moveimpdir/$expdate - This is the directory that I extracted
> the .ixf files into.
> mv db2move.lst db2move.lst.orig - Copy the original db2move.lst so I
> can SED it using the next line.
> sed -e "/$fromdbuser/ s//$todbuser/g" db2move.lst.orig > db2move.lst
>
> `db2move "$todbname" load` - Still in the directory I run the command
> wait
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> +++
> LOAD.out error:
>
> *** Table "DB8INST1"."ALCO_LOGIN_SESSION":  ERROR 3107.  Check message
> file tab359.msg!
>
> ***  SQL Warning!  SQLCODE is  3107
>
> ***  SQL3107W  There is at least one warning message in the message
> file.
>
> +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> +++
>
> root@hopdb1 # more tab359.msg
>
> SQL3104N  The Export utility is beginning to export data to file
> "tab359.ixf".
>
> SQL3105N  The Export utility has finished exporting "7" rows.
>
> SQL3501W  The table space(s) in which the table resides will not be
> placed in
>
> backup pending state since forward recovery is disabled for the
> database.
>
> SQL3039W  The memory available to LOAD for DATA BUFFER prohibits full
> LOAD
>
> parallelism.  Load parallelism of "1" will be used
>
> SQL3109N  The utility is beginning to load data from file
>
> "/backups/eldtest/dba/db2import/db2move/20071015/tab359.ixf".
>
> SQL3500W  The utility is beginning the "LOAD" phase at time
> "10-29-2007
>
> 07:40:53.079771".
>
> SQL3150N  The H record in the PC/IXF file has product "DB2    02.00",
> date
>
> "20071015", and time "084357".
>
> SQL3153N  The T record in the PC/IXF file has name "tab359.ixf",
> qualifier "",
>
> and source "            ".
>
> SQL3168W  The PC/IXF column specified to be loaded into database
> column "5" is
>
> not compatible with the database column.  Nulls will be inserted.
>
> SQL3519W  Begin Load Consistency Point. Input record count = "0".
>
> SQL3520W  Load Consistency Point was successful.
>
> SQL3110N  The utility has completed processing.  "7" rows were read
> from the
>
> input file.
>
> SQL3519W  Begin Load Consistency Point. Input record count = "7".
>
> SQL3520W  Load Consistency Point was successful.
>
> SQL3515W  The utility has finished the "LOAD" phase at time
> "10-29-2007
>
> 07:40:53.253147".
>
> SQL3500W  The utility is beginning the "BUILD" phase at time
> "10-29-2007
>
> 07:40:53.300471".
>
> SQL3213I  The indexing mode is "REBUILD".
>
> SQL3515W  The utility has finished the "BUILD" phase at time
> "10-29-2007
>
> 07:40:53.529893".
>
> SQL3107W  There is at least one warning message in the message file.

AFAIK db2 thinks there a difference between the table you are
exporting from and the table you are loading to (column 5). Can you
post a describe of both tables?

/Lennart

-1
Lennart
10/31/2007 8:32:43 PM
On Oct 31, 4:32 pm, Lennart <Erik.Lennart.Jons...@gmail.com> wrote:
> On Oct 31, 4:59 pm, EricDeWerth <Eric.DeWe...@gmail.com> wrote:
>
>
>
>
>
> > When I try to call db2move $todbname load from a shell script it will
> > give me this error in the log.  When I call it from the command line
> > using the exact same dataset it works perfectly.  Does anyone know
> > what might be causing that to occur?  Below is the .msg file.
>
> > Thanks for any help.  I really need to put this script to bed.  This
> > is the last hangup.
>
> > Regards
> > Eric
>
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > ++
> > Script snippet:
> > #
> > # Import Data
> > #
> > cd $db2moveimpdir/$expdate - This is the directory that I extracted
> > the .ixf files into.
> > mv db2move.lst db2move.lst.orig - Copy the original db2move.lst so I
> > can SED it using the next line.
> > sed -e "/$fromdbuser/ s//$todbuser/g" db2move.lst.orig > db2move.lst
>
> > `db2move "$todbname" load` - Still in the directory I run the command
> > wait
>
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > +++
> > LOAD.out error:
>
> > *** Table "DB8INST1"."ALCO_LOGIN_SESSION":  ERROR 3107.  Check message
> > file tab359.msg!
>
> > ***  SQL Warning!  SQLCODE is  3107
>
> > ***  SQL3107W  There is at least one warning message in the message
> > file.
>
> > +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> > +++
>
> > root@hopdb1 # more tab359.msg
>
> > SQL3104N  The Export utility is beginning to export data to file
> > "tab359.ixf".
>
> > SQL3105N  The Export utility has finished exporting "7" rows.
>
> > SQL3501W  The table space(s) in which the table resides will not be
> > placed in
>
> > backup pending state since forward recovery is disabled for the
> > database.
>
> > SQL3039W  The memory available to LOAD for DATA BUFFER prohibits full
> > LOAD
>
> > parallelism.  Load parallelism of "1" will be used
>
> > SQL3109N  The utility is beginning to load data from file
>
> > "/backups/eldtest/dba/db2import/db2move/20071015/tab359.ixf".
>
> > SQL3500W  The utility is beginning the "LOAD" phase at time
> > "10-29-2007
>
> > 07:40:53.079771".
>
> > SQL3150N  The H record in the PC/IXF file has product "DB2    02.00",
> > date
>
> > "20071015", and time "084357".
>
> > SQL3153N  The T record in the PC/IXF file has name "tab359.ixf",
> > qualifier "",
>
> > and source "            ".
>
> > SQL3168W  The PC/IXF column specified to be loaded into database
> > column "5" is
>
> > not compatible with the database column.  Nulls will be inserted.
>
> > SQL3519W  Begin Load Consistency Point. Input record count = "0".
>
> > SQL3520W  Load Consistency Point was successful.
>
> > SQL3110N  The utility has completed processing.  "7" rows were read
> > from the
>
> > input file.
>
> > SQL3519W  Begin Load Consistency Point. Input record count = "7".
>
> > SQL3520W  Load Consistency Point was successful.
>
> > SQL3515W  The utility has finished the "LOAD" phase at time
> > "10-29-2007
>
> > 07:40:53.253147".
>
> > SQL3500W  The utility is beginning the "BUILD" phase at time
> > "10-29-2007
>
> > 07:40:53.300471".
>
> > SQL3213I  The indexing mode is "REBUILD".
>
> > SQL3515W  The utility has finished the "BUILD" phase at time
> > "10-29-2007
>
> > 07:40:53.529893".
>
> > SQL3107W  There is at least one warning message in the message file.
>
> AFAIK db2 thinks there a difference between the table you are
> exporting from and the table you are loading to (column 5). Can you
> post a describe of both tables?
>
> /Lennart- Hide quoted text -
>
> - Show quoted text -

This is the describe of the ALCO_LOGIN_SESSION table that it came
from:
db2 => describe table ALCO_LOGIN_SESSION

Column                         Type      Type
name                           schema    name               Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- -----                                  -
LOGIN_SESSION_ID               SYSIBM    INTEGER
4     0 No
SESSION_NUM                    SYSIBM    INTEGER
4     0 Yes
LOGIN_TIME                     SYSIBM    TIMESTAMP
10     0 Yes
SERVER                         SYSIBM    VARCHAR
255     0 Yes
USER_ID                        SYSIBM    INTEGER
4     0 Yes
CONNECTION_ID                  SYSIBM    VARCHAR
255     0 Yes
PROXY_USER_ID                  SYSIBM    INTEGER
4     0 Yes

  7 record(s) selected.



This is the table that it is going to:
db2 => describe table ALCO_LOGIN_SESSION

Column                         Type      Type
name                           schema    name               Length
Scale Nulls
------------------------------ --------- ------------------ --------
----- ------
LOGIN_SESSION_ID               SYSIBM    INTEGER
4     0 No
SESSION_NUM                    SYSIBM    INTEGER
4     0 Yes
LOGIN_TIME                     SYSIBM    TIMESTAMP
10     0 Yes
SERVER                         SYSIBM    VARCHAR
255     0 Yes
USER_ID                        SYSIBM    INTEGER
4     0 Yes
PROXY_USER_ID                  SYSIBM    INTEGER
4     0 Yes

  6 record(s) selected.


It looks like you are correct that it is a table issue.  I'll have to
check my code but I guess my SED command might stripping out a little
to much when I split the entire ddl for a create on tables and pk and
separate create for fk.

Thanks for the insight,
Eric

0
EricDeWerth
11/1/2007 3:34:06 PM
Reply: