CODEWITHSUNDEEP
sqldb2ibm-cloudpurge
vikram
vikram

Reputation: 61

Best Practice for Purging data from db2 sql service

What is the best practice to be used on Bluemix for purging of data from the db2 storage service? Say we want to purge a large amount of data, say a million entries of a particular communication to customers ?

Upvotes: 0

Views: 526

Answers (1)

CharlesL
CharlesL

Reputation: 942

You may look into this tutorial that describes the data purge algorithm for DB2.

http://www.ibm.com/developerworks/data/library/techarticle/dm-1501data-purge-db2/index.html

However, as SQL Database is a fully managed service, you will not be able to follow the exact instructions as described. For example, you will not be able to tune db cfg and dbm cfg for optimal performance. Also note that you will not have access to a shell script, so you may have to enter individual SQL command individually through a client like data studio.

On the other hand, if you are using the DB2 on Cloud service, it would be able to follow the above instructions.

Upvotes: 1

Related Questions