ps低音炮 2017-05-16 07:18 采纳率: 0%
浏览 2683

db2 load 导入自动截取

我在使用db2 load 命令导入文件时,文件中超长的字段在导入过程中给默认截取掉了,而且数据类型不一致的字段,导入到目标表中默认为null,而且最终导入完成后的统计信息也没有报错,显示全部导入成功,很费解,求大神帮忙!!!
日志如下:
**SQL3500W The utility is beginning the "LOAD" phase at time "2017-05-15
09:02:23.558649".

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

SQL3520W Load Consistency Point was successful.

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

SQL3123W The field value in row "F0-6" and column "6" cannot be converted to
a PACKED DECIMAL value. A null was loaded.

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

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

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

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

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

SQL3520W Load Consistency Point was successful.

SQL3515W The utility has finished the "LOAD" phase at time "2017-05-15
09:02:23.666979".

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

Number of rows read = 12
Number of rows skipped = 0
Number of rows loaded = 12
Number of rows rejected = 0
Number of rows deleted = 0
Number of rows committed = 12**

  • 写回答

1条回答 默认 最新

  • 诸葛大龙 2021-11-08 10:32
    关注

    1.查看这个load语句执行后的返回值错误码,根据返回值错误码判断导入的情况,如:返回值0代表正常,返回值2代表多个警告信息…
    2.看你这个情况,很可能是导入的数据字段超长,导入语句执行的返回值一般是2,如果确认字段内容不影响正常业务,可以忽略。否则,考虑一下字段扩长吧

    评论

报告相同问题?

悬赏问题

  • ¥15 有兄弟姐妹会用word插图功能制作类似citespace的图片吗?
  • ¥200 uniapp长期运行卡死问题解决
  • ¥15 请教:如何用postman调用本地虚拟机区块链接上的合约?
  • ¥15 为什么使用javacv转封装rtsp为rtmp时出现如下问题:[h264 @ 000000004faf7500]no frame?
  • ¥15 乘性高斯噪声在深度学习网络中的应用
  • ¥15 关于docker部署flink集成hadoop的yarn,请教个问题 flink启动yarn-session.sh连不上hadoop,这个整了好几天一直不行,求帮忙看一下怎么解决
  • ¥15 深度学习根据CNN网络模型,搭建BP模型并训练MNIST数据集
  • ¥15 C++ 头文件/宏冲突问题解决
  • ¥15 用comsol模拟大气湍流通过底部加热(温度不同)的腔体
  • ¥50 安卓adb backup备份子用户应用数据失败