Differences

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

--- database:db2 [2024/05/06 18:09]
manu
+++ database:db2 [2025/07/09 13:54] (current)
manu [Suppress Archogs]
@@ Line 153: / Line 153: @@
 </cli>
+===== Update a user password =====
+For example, use the CONNECT statement to change the password of the user instance,
+<cli prompt='$'>
+$ db2 "CONNECT TO <database> USER <userid> USING <password> NEW <new_password> CONFIRM <new_password>"
+</cli>
 ===== DB2 list command =====
@@ Line 338: / Line 343: @@
 </cli>
+==== Suppress Archlogs ====
+When doing online backup, you have to manually purge and suppress archlogs:
+Example suppress archlogs older than 100 days, before 2024/12:
+<cli prompt='$'>
+$ db2 connect to TSMDB1
+$ db2 list history TSMDB1 | grep X |grep D
+$ db2 prune history 202412 with force option and delete
+$ find /db2archlog/db2inst1/TSMDB1 -type f -name "*.LOG" -ctime +100 -exec rm {} \;
+</cli>
 ===== Backup/restore DB2 database =====
@@ Line 869: / Line 887: @@
 https://datageek.blog/2014/06/02/how-to-tell-when-a-table-reorg-is-needed/
+===== Uninstall DB2 =====
+<cli prompt='#'>
+[root@lnx01] /tmp/db2/universal # ./db2_deinstall -a -b /opt/ibm/db2/V11.5
+DBI1016I  Program db2_deinstall is performing uninstallation. Please
+</cli>

wiki