ERROR [42704] [IBM][DB2/] SQL0204N "SYSIBMADM.ENV_CF_SYS_RESOURCES" is an undefined name.
说明
When going to the Capacity Tool/Space Management using a DB2 LUW database v9.x, Toad will create an script and send it to the Editor with the purpose of creating a procedure. When trying to run this script, Toad will show the error:
"ERROR [42704] [IBM][DB2/<OS>] SQL0204N "SYSIBMADM.ENV_CF_SYS_RESOURCES" is an undefined name."
Same script works in v10.x environments.
原因
Capacity Tool is only available for DB2 LUW version 10 and above. Change Request TDB-2739 was created to disable the ‘Capacity’ button when the LUW version is less than v10.
解决办法
WORKAROUND: None.
STATUS: Waiting for a fix in a future release of Toad for DB2 LUW.
