Example: LIST TABLESPACE CONTAINERS FOR 1 30. 显示用户数据库的存取权限 GET AUTHORIZATIONS 31. 启动实例 DB2START 32. 停止实例 db2stop 33. 表或视图特权 grant select,delete,insert,update on tables to user grant all on tables to user WIT
This is a typical example of how to archive and extract a delimited ASCII file in a partitioned database environment. The Windows remove (rm) command deletes the old delimited ASCII files. rm /auditdelasc/*.del db2audit flush db2audit archive database mydb to /auditarchive The files will...
The following example is sample output from the command db2adutl delete full taken at 20031209184503 db rawsampl: Query for database RAWSAMPL Retrieving FULL DATABASE BACKUP information. Taken at: 20031209184503 Log stream: 0 Sessions: 1 Do you want to delete this file (Y/N)? y Are you ...
(' DELETE FROM SYSIBM.USERNAMES WHERE LINKNAME = ''HISDRDA1'' ') AT DRDA_AS_Example; GO EXECUTE (' INSERT INTO SYSIBM.USERNAMES VALUES (''O'', ''DBUSRID'', ''HISDRDA1'', ''', ''DBUSRPWD'', ''N'') ') AT DRDA_AS_Example; GO EXECUTE (' SELECT * FROM SYSIBM.LOCATIONS ...
2. 通过 Command Editor( 在 DB2 8.2 版本之前叫做 Command Center) 获得可视化的查询计划。如图 2: 图2. 获得可视化的查询计划 获得可视化的查询计划 在主窗口输入查询并连接数据库后,点击图中所示的按钮即可得到可视化的查询计划,如图 3: 图3. 查询计划结果 ...
Example: LIST TABLESPACE CONTAINERS FOR 1 30. 显示用户数据库的存取权限 GET AUTHORIZATIONS 31. 启动实例 DB2START 32. 停止实例 db2stop 33. 表或视图特权 grant select,delete,insert,update on tables to user grant all on tables to user WITH GRANT OPTION 34. 程序包特权 GRANT EXECU...
Example: LIST TABLESPACE CONTAINERS FOR 1 30. 显示用户数据库的存取权限 GET AUTHORIZATIONS 31. 启动实例 DB2START 32. 停止实例 db2stop 33. 表或视图特权 grant select,delete,insert,update on tables to user grant all on tables to user WITH GRANT OPTION ...
运行reorg、runstats命令,清除已delete的数据,优化数据结构。 db2 reorg table 表名 db2 runstats on table 表名 with distribution and indexes all 因为要优化的表比较多,所以在/btp/bin目录下提供了一个sh程序runsall, 可在当天业务结束后,运行runsall,对数据库进行优化 ...
Delete row Delete row or rows. Execute a stored procedure Stored procedure Execute non-query Execute a SQL command that does not return a result set. Execute query Execute a SQL query. Insert row Insert a row. Update rows Update row or rows. DB2 tables Operation ID: getTables Return ta...
1istcommandoptions 27-系统数据库目录 LISTDATABASEDIRECTORY 28,表空间 Tisttablespaces 29,表空间容器 LISTTABLESPACECONTAINERSFOR Example:LISTTABLESPACECONTAINERSFOR1 30.显示用户数据库的存取权限 GETAUTHORIZATIONS 31。启动实例 DB2START 32.停止实例 db2stop 33。表或视图特权 SgTantselect,delete,insert,Updateon...