Search results for query: *

I have this query and the output: select ptloc, RMOutcomeAct, RMOutcomePot, count (RMOutcomeAct) as ActCount, count (RMOutcomePot) as PotCount, sum(RxDoseAct) as ActSUM, sum(RxDosePot) as PotSUM from Report r, RMInvest m, PharmInvest p, AdminInvest a where r.ReportNo = m.RMReportNo and...

Can you please share system recovery steps with a mksysb in a DVD? I like to document the steps for bring up AIX nodes on other AIX machines if there are severe system failures. In that case, I will have to use a mksysb in DVD and other data from TSM backup tapes. thx much

// AIX 5.2 and Oracle 9i I have the LVs under /dev: root:/dev> ls -lrt |grep rprod bla ..... crw------- 1 oracle dba 46, 48 Dec 04 11:55 rprod_0384_002 crw------- 1 oracle dba 46, 85 Dec 04 11:55 rprod_1024_149 crw------- 1 oracle dba 46, 95 Dec 04 11:55...

It is confusing if I can remove the PID or not.

PDC # w 10:36AM up 5 days, 18:11, 1 user, load average: 0.00, 0.01, 0.01 User tty login@ idle JCPU PCPU what root pts/0 Thu11AM 0 1:46 0 /usr/bin/w64 You have mail in /usr/spool/mail/root root:/> PDC # ps -ft pts/0 UID...

What is this error? LABEL: LVM_SA_QUORCLOSE IDENTIFIER: CAD234BE Class: H Type: UNKN Resource Name: LVDD Resource Class: NONE Resource Type: NONE Location: Description QUORUM LOST, VOLUME GROUP CLOSING Probable Causes PHYSICAL VOLUME UNAVAILABLE Detail...

I have extended the lv for the lg_dump, but still getting it. IDENTIFIER TIMESTAMP T C RESOURCE_NAME DESCRIPTION 837E0DE7 0303150007 P O dumpcheck The largest dump device is too small. What is the exact implication of this error? I can't extend the lv on and on. thx much

How do you kill i.e. this tty session? User tty login@ idle JCPU PCPU what root pts/0 Thu11AM 21:20 5:24 0 -ksh thx much

I am in the process of developing I am in the process of developing Disaster Recovery plans for AIX nodes: HW Recovery Plan Disaster Recovery Test Results Report Disaster Recovery Test SW Restore Plan Disaster Recovery Test Can you please share any type of templates for the tests above so...

thx much!!!!

I have a .ksh, and it returns outputs if I run it under root manually. However, if it runs under crontab under root, it does NOT return any output. What would be the issue? thx

thx so much!!

I have this script, and I want the output sorted by first, $date="$month/$day/$year"; and then $otime="$hours:$minutes:$seconds"; thx much #!/usr/bin/perl open (PASSWD,"/etc/passwd") or die "Cannot open /etc/passwd: $!\n"; while (<PASSWD>) {...

I think you mean this? df -k | grep -v /backup | grep -v -i filesystem | grep -v ":" | awk '{print $7,substr($4,1,2)}' | grep -v "%" | grep -v proc > $WORKDIR/freespace.lst

where do I need to plug the line in? thx much

I have df -k file system monitor script below. What I need is to exclude /backup filesystem because it is always around 98 or 99%. How do you put the line for excluding the /backup? bla... ALERT_ADMIN () { mail -s "${MAIL_SUBJ}" $DIST_LIST << EOF Filesystem $fsname has reached $sz% of its...

oh.. It was from: fuser -dV /

I am getting: /: inode=1164 size=1987045 fd=0 10044 What does this mean?

This is weird... I am seeing this: $ ls -al |grep vg46 crw------- 1 root system 46, 0 Dec 04 16:20 __vg46

>> Perhaps at one time you tried to delete an open file which was growing, and still is growing as the process accountable for it still has the file open, only you can't see it anymore? Is there a way to find the invisible file w/o reboot?