select department_id,listagg(department_name, \',\') WITHIN GROUP(ORDER BY department_name) department_name from T_WX_CORP_DEPARTMENT group by department_id;DB2数据库10.1执行该语句时,报错:Lookup Error - DB2 Database Error: ERROR [42601] [IBM...(more)
请问这个实例用户为什么会占用这么高?我这台库是配了16个节点的,正常db2sysc进程是有16个的吧?我在上次停机的时候没有执行ipclean是否有影响之前的db2sysc没有清理干净?DB2版本:9.1.0.12操作系统:Sun OS 5.10 Generic_150400-04[tr] [td][/td][/tr]物理...(more)
在安装DB2 Express-C V9.7 版本时出现错误,点击setup.exe开始安装就出现报错信息为:“Failure reading properties files.Ifyou are running this program from a UNC path,map the path to a drive and start this program again from the mapped drive.” 然后点击确定后...(more)
平台是z/OS,DB2 V10.1 根据下边的文档说明,运行Capture程序的ID必须对所有的replication tables有SELECT, UPDATE, INSERT, and DELETE的权限,这里的replication tables包括了source表,CD表,CCD表这些吗?z/OS®The user ID used to run the Capture program must be register...(more)
list history load all for db dbname下面是错误提示,请问啥意思?明明有150个匹配的,但是就是列不出来,为啥?Number of matching file entries = 150SQL2155W Changes have been made to the recovery history file since the openscan was issued....(more)