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...

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...

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...

The size of / (root) is growing up so fast, but I am not seeing significant sizes of files under /. I can't keep adding spaces. What could cause this issue on AIX 5.1.4?

What is the message trying to tell us? LABEL: LVM_QUORUMNOQUORUM IDENTIFIER: 5BEAD71B Class: S Type: INFO Resource Name: LIBLVM Description Activation of a no quorum volume group with out 100% of the disks Probable Causes One or more physical...

on smit user It is set to false: User can LOGIN REMOTELY(rsh,tn,rlogin)? false but, still root is accessible remotely. Am I missing something? thx

I am in need of two ksh scripts. errpt - want to rcv e-mail for **new** errpt lines rather than the entire errpt contents. df -k - want to rcv e-mail if the % used is over 90%, but I want to exclude some of filesystems as to some of them are always 95 % or higher. thx much

some keps removing /etc/filesystems -rw-r--r-- 1 root system 0 Feb 22 23:00 filesystems What is the best way to trace back who touched it?

I am sure I saw an IBM training class dealing with AIX 5L filesystem recovery, filesystem check, inode, troubleshoot, etc, but I can't find it. Does anyone know what class it would be? thx much

// AIX 5.1.4 root:/> mount /temp01 mount: 0506-324 Cannot mount /dev/temp01lv on /temp01: The requested resource is busy. How do you fix this?

On IE 6.0, flashes are behaving as if they're links when you hover the mouse over it with the message, “Press SpaceBar or Enter to activate and us this control”. Is there a way to remove the behavior? thx

I want to pass the integer with <STDIN> rather than hardcode it. The code below has all 1 (one), but it can be 2, 3 4, etc. On <STDIN>, I want to put regex so that it will only accept integer; otherwise, the prompt asks until the integer is entered. bla... @H=(' ',split//,$a); @V=('...

On IE 6.0, the gifs and flashes are behaving as if they're links when you hover the mouse over it with the message, “Press SpaceBar or Enter to activate and us this control”. Is there a way to remove the behavior? thx