Manually prune HCL Connection databases on DB2
DB2 archive logs keeps on growing on my server. I don’t know why this is happening, but i resolved it by manually delete the archive history after a full backup.…
DB2 archive logs keeps on growing on my server. I don’t know why this is happening, but i resolved it by manually delete the archive history after a full backup.…
Follow up on my blog about moving to an online DB2 backup: https://www.angioni.nl/2020/03/26/transitioning-to-online-backup-in-db2/ Here is the procedure to restore an online created DB2 database-backup. It’s not a “normal” restore, next,…
When you need an online backup of your DB2 databases, then you have to switch to Archived Transactional Logging. This is the procedure to move over from circular to archived…
#! /bin/shecho “”echo “”echo “List DB2 instances & databases”DB2_INSTALL_PATH=/opt/ibm/db2/V10.1 . /etc/init.d/functions list_instances() { $DB2_INSTALL_PATH/bin/db2greg -dump | grep -E ‘^I,DB2’ | \ cut -d, –output-delimiter=” ” -s -f4,5,7 } #read DB2…
Easy onliner to show the users on a DB2 database. First connect to the corresponding database and in a SQL commander give this command: select char(grantee,8) as grantee, char(granteetype,1) as…
When activities crow to large, the behavior of it cannot be called stable! Saving an entry can result in losing data. IBM made a statement on this behavior and let…
MongoDB and IBM are collaborating to establish new standards for accessing the data layer: BSON, the MongoDB write protocol and the MongoDB query language. IBM is working to implement the…
Using the following procedure at IBM: https://www-01.ibm.com/support/knowledgecenter/SSEPGG_10.5.0/com.ibm.db2.luw.qb.upgrade.doc/doc/c0011933.html Globally: you install a new copy of DB2 10.5 and perform a instance upgrade. Procedure: Check if the databases are ready to be…