Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
en:services:storage_services:backup:tsm:admin:dbreorg [2018/11/28 11:38]
[Create a temporary table space to use during the reorganization]
en:services:storage_services:backup:tsm:admin:dbreorg [2018/11/28 11:47] (current)
[preparation on windows]
Line 4: Line 4:
   * there is degradation in server performance. ​   * there is degradation in server performance. ​
  
-===== steps to do ===== +**steps to do:** 
-==== preparation on windows ​====+===== preparation  ​===== 
 +==== Windows ​==== 
 The DB2 commandline needs to be run as that user who runs the DB2 and TSM/ISP instance. **Administrative permissions / privileges** are **not suffiecient!** The DB2 commandline needs to be run as that user who runs the DB2 and TSM/ISP instance. **Administrative permissions / privileges** are **not suffiecient!**
  
Line 13: Line 15:
 \\  \\ 
 Notice:\\ You'll be asked for the user's password! Notice:\\ You'll be asked for the user's password!
-=== Determine temporary space ===+ 
 +==== Linux ==== 
 +the commands must be issued with the userspace of the instance owner so 
 +  * //sudo// every command: ''​sudo <​instance owner>''​ -- or 
 +  * become instance-user using a login shell: ''​sudo -i <​instance owner>''​ 
 + 
 +then //cd// to the instance'​s home config directory FIXME 
 + 
 +===== Determine temporary space =====
 //When the server is running, determine the amount of temporary space that is required to organize a table. The temporary space that is required is twice the value of the table size. To determine the table size, issue the following commands// //When the server is running, determine the amount of temporary space that is required to organize a table. The temporary space that is required is twice the value of the table size. To determine the table size, issue the following commands//
 <​code>​ <​code>​
Line 25: Line 35:
 </​code>​\\ </​code>​\\
 so directing the output to files with skipping all the blanks looks like: so directing the output to files with skipping all the blanks looks like:
-  * Windows:+==== Windows ​==== 
 <​code>​mkdir c:\DB2Stats <​code>​mkdir c:\DB2Stats
 db2 call sysproc.reorgchk_tb_stats('​T','​tsmdb1.AF_BITFILES'​) db2 call sysproc.reorgchk_tb_stats('​T','​tsmdb1.AF_BITFILES'​)
Line 46: Line 57:
 db2 "​EXPORT TO c:​\DB2Stats\ARCHIVE_OBJECTS.csv OF DEL MODIFIED BY NOCHARDEL ​ select '​ARCHIVE_OBJECTS:​ ' || TRIM(tsize) as ARCHIVE_OBJECTS from session.tb_stats"​ db2 "​EXPORT TO c:​\DB2Stats\ARCHIVE_OBJECTS.csv OF DEL MODIFIED BY NOCHARDEL ​ select '​ARCHIVE_OBJECTS:​ ' || TRIM(tsize) as ARCHIVE_OBJECTS from session.tb_stats"​
 </​code>​ </​code>​
-__Underlined Text__=== Create a temporary table space to use during the reorganization ===+==== Linux ==== 
 +FIXME 
 +===== Create a temporary table space to use during the reorganization ​=====
 //Create a temporary table space to use during the reorganization. Issue the following commands:// //Create a temporary table space to use during the reorganization. Issue the following commands://
 <​code>​ <​code>​