How to redirect zip to another folder

Question: When attempting to use gzip on Linux and zip the file - I tried by going to another folder and completing the gzip command as normal. As an example: Move to another folder , the intended target for the zipped file Execute code as similar gzip /myfolder/file.txt I discovered it was gzip in the same folder as the source folder. Not zipping the file in the target folder. Is it possible to gzip and redirect to another folder? Answer: You need to use the -c switch So if you need to redirect the zip file to the intended target... Read more →

DB2 move fenced user home directory

Question: I’d like to move the DB2 fenced user to a different location. The OS is Linux. There is a bug in the client application which when using DB2 and the fenced user home directory is in the same path as DB2. Answer: It is an easy process . The first step is to find out the fenced user. You can identify the fenced user with the command: Db2pd –fmp | grep –i fenced The you can use the Linux command : usermod -m -d /path/to/new/login/home/dir . This command changes user home directory to a new login directory. Option –d... Read more →

Will Leap Second crash DB2?

Question: What is a leap second and how will it impact my DB2 servers ? I have a bunch of DB2 servers hosted on Red Hat Linux 6. Answer: It’s important to understand the definition of a leap second . I’m quoting from Wikipedia “A leap second is a one-second adjustment that is occasionally applied to Coordinated Universal Time (UTC) in order to keep its time of day close to the mean solar time, or UT1. Without such a correction, time reckoned by Earth's rotation drifts away from atomic time because of irregularities in the Earth's rate of rotation. Since... Read more →

Check DB2 instance status

How to check for the DB2 Instance Status? There are multiple methods of checking the DB2 instance status. The method is usually dependant on the requirements. These are some examples of different situations where the DB2 instance status is required Server reboot – Has the DB2 instance started OK?Maybe auto start failed or an underlying disk issue. Connection troubleshooting – Is the DB2 instance available? Disaster Recovery – On a site failover , has the DB2 instance started OK? Typically a DBA may go beyond checking just the DB2 instance status. They may want to check database connections , tablespaces... Read more →

Linux swap space and DB2

To view the linux swap space and usage ,use one of these commands Swapon –s Cat /proc/swaps Monitoring the Linux swap space is important as the usage levels are a good indicator more memory may be required. The general rule of thumb for the Linux swap space sizing , based on the IBM DB2 database product documentation, is 25% - 50% of physical RAM. It’s a guideline figure , and the DBA will need to do some memory usage planning. If you're seeing constant swapping , then organise some extra memory. To view swapping use this command: vmstat 3 100... Read more →