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...
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
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...
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
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 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...
>> 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?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.