When DS Change plan generate deployment scripts, DB2 CLP commands such as EXPORT, RUNSTATS, REORG are being executed via CALL SYSPROC.ADMIN_CMD.
Is there a way to generate the CLP command as is, i.e. 'EXPORT TO ... MESSAGES .... SELECT ... FROM ...' without calling this stored procedure?
This topic has been locked.
3 replies Latest Post - 2012-12-20T21:58:56Z by loicjulien
Pinned topic Any option not to use SYSPROC.ADMIN_CMD in generated command
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-20T21:58:56Z at 2012-12-20T21:58:56Z by loicjulien
loicjulien 2700007DEB96 PostsACCEPTED ANSWER
Re: Any option not to use SYSPROC.ADMIN_CMD in generated command2012-12-19T00:18:43Z in response to SystemAdminHi Jie Wu,
There is an Edit button within the Command section. You can select it, and this will copy over the commands into the SQL Editor. Once in the SQL Editor, you can modify the command and run with the CLP execution method.
The SQL Editor is also the place where you can schedule your script for execution within the Data Studio Web Console so this is a good tip to know.
Let me know,
SystemAdmin 110000D4XK1632 PostsACCEPTED ANSWER
Re: Any option not to use SYSPROC.ADMIN_CMD in generated command2012-12-19T14:47:00Z in response to SystemAdminHi,
Thank you for the response. Instead of manually editing, is there a way to make it GENERATED with the simple CLP statement without SYSPROC.ADMIN_CMD?