Chinaunix
标题:
关于runsqlstm命令
[打印本页]
作者:
cyberspace4601
时间:
2008-10-18 10:42
标题:
关于runsqlstm命令
通过此命令建立的DB和通过DDS建立的DB有哪些不同呢??
我通过runsqlstm建立了个DB,但是最大MBR数好像只能是1,不知道可以修改最大MBR数吗??
如果可以,怎样修改呢??
作者:
qingzhou
时间:
2008-10-18 14:01
刚才测试了下,的确存在这个问题,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 编辑
]
作者:
digitalchina
时间:
2008-10-20 12:04
addpfm 不能用吗?
欢迎光临 Chinaunix (http://bbs.chinaunix.net/)
Powered by Discuz! X3.2