- 论坛徽章:
- 0
|
刚才测试了下,的确存在这个问题,google下CPD3213好象也没找到有效的解决方法。
http://archive.midrange.com/midrange-l/199712/msg00544.html
似乎要用DDS创建的PF才能修改MAXMBRS(*NOMAX) ?
1. chgcurlib mylib
2.strsql,CREATE TABLE Accounts
3.CHGPF FILE(mylib/Accounts) MAXMBRS(*NOMAX)
MSGID:CPD3213
- Additional Message Information
-
- Message ID . . . . . . : CPD3213 Severity . . . . . . . : 40
- Message type . . . . . : Information
- Date sent . . . . . . : 10/18/08 Time sent . . . . . . : 13:31:34
-
- Message . . . . : Maximum-member value not valid for file ACCOUNTS.
- Cause . . . . . : File ACCOUNTS in library MYLIB is either a Structured
- Query Language (SQL) table, view or index, or a non-SQL file that is an SQL
- materialized query table or is in SQL data base MYLIB.
- SQL tables, views, and indexes, and non-SQL files that are an SQL
- materialized query table or are in an SQL data base must have only one
- member; however, the value that you specified on the maximum number of
- members (MAXMBRS) parameter is either a number greater than one or *NOMAX.
- For more information about SQL tables, views and indexes, see the DB2 UDB
- for iSeries SQL Programming topic in the Information Center,
- [url]http://www.ibm.com/eserver/iseries/infocenter[/url]
- Recovery . . . : Change the value in the MAXMBRS parameter to 1 or *SAME,
- and try the request again.
- Bottom
-
- F3=Exit F6=Print F9=Display message details
- F10=Display messages in job log F12=Cancel F21=Select assistance level
复制代码
[ 本帖最后由 qingzhou 于 2008-12-5 09:39 编辑 ] |
|