Voltar
-
Título
ERROR [42704] [IBM][DB2/] SQL0204N "SYSIBMADM.ENV_CF_SYS_RESOURCES" is an undefined name. -
Descrição
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.
-
Causa
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.
-
Resolução
WORKAROUND:
None.
STATUS:
Waiting for a fix in a future release of Toad for DB2 LUW. -
ID do defeito
TDB-2739