求助:DB2数据库方面的问题

今天在向DB2数据库中load数据时出错,在网上查了一下,没有查到解决办法,哪位高手能不能帮忙看一下:

DB20000I  The SQL command completed successfully.
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.

SQL3109N  The utility is beginning to load data from file
"/cmod/od_data/mobileData/syn/month/20090210/TDNATIONAL_20090210001.dat".

SQL3500W  The utility is beginning the "LOAD" phase at time "02/10/2009
13:14:57.346792".

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

SQL3520W  Load Consistency Point was successful.

SQL3125W  The character data in row "F0-1" and column "1" was truncated
because the data is longer than the target database column.

SQL3137W  Row "F0-1" is too short.  At least one input value being loaded to a
non-nullable column is missing.  The row was not loaded.

SQL3185W  The previous error occurred while processing data from row "F0-1" of
the input file.

SQL3125W  The character data in row "F0-2" and column "1" was truncated
because the data is longer than the target database column.

SQL3137W  Row "F0-2" is too short.  At least one input value being loaded to a
non-nullable column is missing.  The row was not loaded.

SQL3185W  The previous error occurred while processing data from row "F0-2" of
the input file.

SQL3125W  The character data in row "F0-3" and column "1" was truncated
because the data is longer than the target database column.

SQL3137W  Row "F0-3" is too short.  At least one input value being loaded to a
non-nullable column is missing.  The row was not loaded.

SQL3185W  The previous error occurred while processing data from row "F0-3" of
the input file.

SQL3227W  Record token "F0-1" refers to user record number "1".

SQL3227W  Record token "F0-2" refers to user record number "2".

SQL3227W  Record token "F0-3" refers to user record number "3".

SQL3110N  The utility has completed processing.  "3" rows were read from the
input file.

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

SQL3520W  Load Consistency Point was successful.

SQL3515W  The utility has finished the "LOAD" phase at time "02/10/2009
13:14:57.741537".

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


Number of rows read         = 3
Number of rows skipped      = 0
Number of rows loaded       = 0
Number of rows rejected     = 3
Number of rows deleted      = 0
Number of rows committed    = 3

DB20000I  The SQL DISCONNECT command completed successfully.

 

 

我查看了一下数据,数据字段和数据库表的字段都是没有问题的。

  • 0
    点赞
  • 1
    收藏
    觉得还不错? 一键收藏
  • 5
    评论
DB2数据库客户端是用于连接和管理DB2数据库的软件工具。它提供了一个用户友好的界面,使用户能够轻松地执行数据库管理任务和查询。 DB2数据库客户端具有以下几个主要功能: 1. 连接数据库DB2数据库客户端允许用户通过网络连接到远程DB2数据库。用户可以通过指定数据库的地址、端口、用户名和密码来建立连接。 2. 管理数据库:用户可以使用DB2数据库客户端对数据库进行管理操作。这包括创建新的数据库、删除已有数据库、备份和恢复数据库、调整数据库参数等。 3. 执行SQL查询:DB2数据库客户端提供了一个SQL查询界面,使用户能够执行各种数据库查询操作。用户可以编写SQL语句来获取所需的数据,并在结果集中查看查询结果。 4. 数据导入和导出:DB2数据库客户端允许用户将数据从其他数据源导入到DB2数据库中,或将数据库中的数据导出到其他格式,如CSV、Excel等。这对于数据迁移和共享非常有用。 5. 监控性能:DB2数据库客户端提供了一些工具和指标,用于监控数据库的性能。用户可以查看数据库的运行状况、查询执行计划以及诊断和解决性能问题。 总之,DB2数据库客户端是一个功能强大的软件工具,为用户提供了连接、管理、查询和监控DB2数据库的能力。它简化了数据库管理工作,提高了工作效率,并为用户提供了更好的数据库使用体验。

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论 5
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值