Search Results

Looks like the output of the select statement is not just 0, but something like 0.

If the status code in the database does not contain blanks, you just could remove the quotes from the case...

I am not sure, if I understand you correctly. Do you mean the SQL SELECT statement or the case-construct afterwards? Can you give an example?

You might want to run db2 -x SELECT ... to get rid of the heading and 1 record(s) selected.

Example forever loop and if status is 0, then break the loop. Case is nice command to use string comparing.


#!/bin/bash
# or ksh
while true
do
# your db code here
# after that:...

I would not worry about real memory reporting 99% with vmstat, nmon or such like, as AIX keeps real memory even when a process ends just in case the same data is needed later. You need to keep an...

If it the out of memory occurs directly after the application or DB2 is started, you might want to check, to which value the parameter database_memory is set, or maybe one of the other memory...

May be your team did not performed a stress test thoroughly, you will put the system to its max limits during that test (before you go live).

I guess, the no of users after go-live crossed the...