在SQL中使用ADMIN_CMD运行DB2的AdminCommand (Like JDBC Run ReOrg)

Categories: Database; Tagged with: ; @ October 3rd, 2010 22:36

在使用JDBC时, 除了运行SQL语句之外, 可通过存储过程ADMIN_CMD运行Administrator Command.

譬如, 你无法通过SQL要求DB2进行ReOrg, 但有了ADMIN_CMD, 可通过以下代码运行:

statement.execute("CALL ADMIN_CMD('REORG TABLE TABLE2')"); // Run ReOrg through JDBC

 

See: http://it.toolbox.com/blogs/db2luw/call-administration-commands-through-sql-admin_cmd-7395

<->



// Proudly powered by Apache, PHP, MySQL, WordPress, Bootstrap, etc,.