Tag «db2»

Db2 V9.5 – How to Shrink Tablespace

db2 9.5 shrink tablespace

After deleting a big set of data from a table, we expect it to get smaller than it was before. But in Db2 V9.5 you need to lower high water mark to shrink unused space in tablespace. After Db2 V9.7 you can use ALTER TABLESPACE command to lower high water mark and reduce a table’s size. …

How to Solve Db2 SQL0752N Error

db2 9.5 shrink tablespace

SQL0752N Error message and explanation of this error is:

SQL0752N error usually occurs on redirected restore. SQL0752N Error means, one or more of your databases is in restore pending state. You must fix problems about restore pending database. First of all you must get output of this simple command:

As you may see, …

How to solve: Db2 is not listening port problem

db2 9.5 shrink tablespace

Sometimes a mistake made by db administrator causes that kind of problem.   To solve this problem we need to take a few simple steps and check system services. First of all, you need to get database service configuration with this command:

Does that value empty? You need to set a port number to …