DB2-错误MCH1210-接收器值太小而无法保存结果 [英] DB2 - Error MCH1210 - Receiver value too small to hold result

问题描述

当我尝试从IBM System iNavigator进行View导出时，我遇到主题错误(MCH1210-接收器值太小，无法保存结果.). 此视图包含大约2百万条记录. 我试图用另一个只包含一些记录(少于100条)的View进行数据导出，并且可以正常工作.

i'm experiencing the error in subject (MCH1210 - Receiver value too small to hold result.) when I try to do a View export from IBM System iNavigator. This View contains around 2 millions record. I tried to do a data export with another View, just with some records (less than 100), and it works properly.

您能帮我解决这个问题吗? 还有其他可能的方法可以实现目标吗?

Could you help me how to solve this issue? Are there any other possible ways to achieve the goal?

提前谢谢！

推荐答案

检查您当前的Service Pack以了解您是否是最新的.在IBM i端检查PTF，以确保您是最新的.一般来说，Navigator中的任何MCH错误都是应报告给IBM的缺陷，但是他们要您做的第一件事就是获取最新信息.

Check your current Service Pack to see if you are current. Check PTFs on the IBM i side to make sure you are current. Generally speaking, any MCH errors in Navigator are a defect that should be reported to IBM, but the first thing they'll want you to do is get current.

检查作业日志(查看">作业日志")以查看潜在的错误.作业日志可能会揭示有关视图的某些信息，从而可以了解情况(例如CAST的数据类型太小).

Check the job log (View > Job log) to see what the underlying error is. The job log might reveal something about the view that sheds light on the situation (like a CAST going to too small a data type).

这篇关于DB2-错误MCH1210-接收器值太小而无法保存结果的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！