Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by AIXFinder

  1. AIXFinder

    Sub-totals with group by

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

    System recovery steps

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

    Finding unallocated LVs

    // 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...
  4. AIXFinder

    kill tty

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

    kill tty

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

    QUORUM LOST, VOLUME GROUP CLOSING

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

    The largest dump device is too small.

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

    kill tty

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

    Disaster Recovery plans for AIX nodes

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

    odd crontab

    thx much!!!!
  11. AIXFinder

    odd crontab

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

    df ksh and exclude a filesystem

    thx so much!!
  13. AIXFinder

    Sort by

    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>) {...
  14. AIXFinder

    df ksh and exclude a filesystem

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

    df ksh and exclude a filesystem

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

Part and Inventory Search

Back
Top