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 …

Fikriyat

Avrupa kıtası için, 20. Yüzyılda yaşanan en önemli olaydan biri Türk Devrimidir. Üstelik bu devrim, dönemin İngiltere’sini sadece Anadoluda rahatsız etmemiş, diğer sömürge devletlerde de isyanlara ve kopmalara neden olmuştur. İran devriminin bile, esas kahramanı Mustafa Kemal Atatürk’tür. Türk Devriminde öne çıkan kişi hiç şüphesiz, Mustafa Kemal Atatürk’tür. Ancak devrimi tasarlayan ve devrimi yapan kadro …

What is Node Js

What is Node Js What is node js? Node js is a runtime that runs Javascript on server side. But not only runs, it also has non-blocking i/o system and asynchronous flow. What does that mean for your code? That simply means, better performance with less hardware costs. Many frameworks for Node js developed by …