audit - Aix

This is a discussion on audit - Aix ; Hi ! I'm charged of auditing AIX machine to prove that AIX machine doesn't handle such huge Oracle appli database. This is in order to convince the client to replace it. What things must I look for ? except disk ...

+ Reply to Thread
Results 1 to 7 of 7

Thread: audit

  1. audit

    Hi !

    I'm charged of auditing AIX machine to prove that AIX machine doesn't
    handle such huge Oracle appli database. This is in order to convince
    the client to replace it.

    What things must I look for ? except disk capacity and Oracle
    performance that are done

  2. Re: audit

    Could you please tell me which model succeeded this one IBM,7028-6C1 ?

    > lscfg -vp


    PLATFORM SPECIFIC

    Name: IBM,7028-6C1
    Model: IBM,7028-6C1
    Node: /
    Device Type: chrp

    Processor Card:
    Part Number.................09P5254
    EC Level....................H11576
    Serial Number...............L081319061
    FRU Number..................09P3666
    Manufacture ID..............1980
    Version.....................RS6K
    Product Specific.
    (ZC).......PS=00165A0BC0,LB=000EE6B280,SB=00059682 F0,

    NP=01,L2=04096,PF=754,SV=3,VR=6,ER=00
    Product Specific.
    (ZB).......BC=90Z01,SG=000000491122334455667788
    Product Specific.
    (ZB).......BC=93Z02,SG=000000490001020304050607080 90A
    0B0C0D0E0F
    System Info Specific.(YL)...P1-C1
    Physical Location: P1-C1

    PS= processor speed in hex

    00165A0BC0 -> 375000000 -> 375 MHz

  3. Re: audit

    to help someone helping me )

    > lscfg -vp


    INSTALLED RESOURCE LIST WITH VPD

    The following resources are installed on your machine.

    Model Architecture: chrp
    Model Implementation: Multiple Processor, PCI bus

    sys0 System Object
    sysplanar0 System Planar
    L2cache0 L2 Cache
    mem0 Memory
    pci1 P1 PCI Bus

    Device Specific.(YL)........P1

    scraid0 P1-I1/Q1 PCI 4-Channel Ultra3 SCSI RAID
    Adapter

    Part Number.................09P1521
    EC Level....................0H10522
    Serial Number...............00217845
    FRU Number..................37L6892
    Manufacturer................IBM
    Displayable Message.........UL3RAID
    Diagnostic Level............04
    Device Driver Level.........04
    Loadable Microcode Level....4.70.11
    ROS Level and ID............4.00.26
    Device Specific.(YL)........P1-I1/Q1

    hdisk2 P1-I1/Q1-L0,0 SCSI Disk Array RAID 5
    pci2 P1-I2 PCI Bus

    Device Specific.(YL)........P1-I2

    lai0 P1-I2/G1 GXT135P Graphics Adapter

    Device Specific.(YL)........P1-I2/G1

    pci0 P1 PCI Bus

    Device Specific.(YL)........P1

    isa0 P1 ISA Bus

    Device Specific.(YL)........P1

    fda0 P1/D1 Standard I/O Diskette Adapter

    Device Specific.(YL)........P1/D1

    fd0 P1-D1 Diskette Drive
    siokma0 P1/K1 Keyboard/Mouse Adapter

    Device Specific.(YL)........P1/K1

    sioka0 P1/K1 Keyboard Adapter
    sioma0 P1/K1 Mouse Adapter
    ppa0 P1/R1 CHRP IEEE1284 (ECP) Parallel Port
    Adapter

    Device Specific.(YL)........P1/R1

    lp0 P1/R1-L0 Other parallel printer
    sa0 P1/S1 Standard I/O Serial Port

    Device Specific.(YL)........P1/S1

    tty0 P1/S1-L0 Asynchronous Terminal
    sa1 P1/S2 Standard I/O Serial Port

    Device Specific.(YL)........P1/S2

    tty1 P1/S2-L0 Asynchronous Terminal
    sa2 P1/S3 Standard I/O Serial Port

    Device Specific.(YL)........P1/S3

    tty2 P1/S3-L0 Asynchronous Terminal
    ide0 P1/Q1 ATA/IDE Controller Device

    Device Specific.(YL)........P1/Q1

    cd0 P1/Q1-L0 IDE CD-ROM Drive I (650 MB)

    Manufacturer................LG
    Machine Type and Model......CD-ROM CRD-8484B
    ROS Level and ID............2.01
    Device Specific.(Z0)........058000211F002212

    scsi0 P1/Z1 Wide/Ultra-3 SCSI I/O Controller

    Device Specific.(YL)........P1/Z1

    hdisk0 P1/Z1-A0 16 Bit LVD SCSI Disk Drive (36400
    MB)

    Manufacturer................IBM
    Machine Type and Model......IC35L036UWDY10-0
    FRU Number..................07N3173
    ROS Level and ID............53323152
    Serial Number...............E3V5PK1B
    EC Level....................H32224
    Part Number.................07N8783
    Device Specific.(Z0)........000003029F00013A
    Device Specific.(Z1)........07N4972
    Device Specific.(Z2)........0068
    Device Specific.(Z3)........02320
    Device Specific.(Z4)........0001
    Device Specific.(Z5)........22
    Device Specific.(Z6)........**********

    hdisk1 P1/Z1-A1 16 Bit LVD SCSI Disk Drive (36400
    MB)

    Manufacturer................IBM
    Machine Type and Model......ST336605LW
    FRU Number..................09P4439
    ROS Level and ID............43353039
    Serial Number...............000087FC
    EC Level....................H11936
    Part Number.................09P4438
    Device Specific.(Z0)........000003129F00013E
    Device Specific.(Z1)........0211C509
    Device Specific.(Z2)........1000
    Device Specific.(Z3)........02041
    Device Specific.(Z4)........0001
    Device Specific.(Z5)........22
    Device Specific.(Z6)........162870 C

    scsi1 P1/Z2 Wide/Ultra-3 SCSI I/O Controller

    Device Specific.(YL)........P1/Z2

    scsi2 P1-I5/Z1 Wide/Fast-20 SCSI I/O Controller

    Device Specific.(YL)........P1-I5/Z1

    rmt0 P1-I5/Z1-A5 Bull DLT8000 40GB Tape Drive

    Manufacturer................QUANTUM
    Machine Type and Model......DLT8000 Bull
    Serial Number...............RBD36P1837
    ROS Level and ID............022B
    Device Specific.(HR)........C003
    Device Specific.(Z0)........0180020233000038
    Device Specific.(Z1)........812B0005190401001387130000000 000
    Device Specific.(Z2)........14-SEP-2000 15:19:15
    Device Specific.(Z3)........99B0494AE8C80F28

    ent0 P1/E1 IBM 10/100 Mbps Ethernet PCI Adapter
    (23100020)

    Network Address.............00025576AD28
    Displayable Message.........PCI Ethernet Adapter (23100020)
    Device Specific.(YL)........P1/E1

    ent1 P1/E2 IBM 10/100 Mbps Ethernet PCI Adapter
    (23100020)

    Network Address.............000255B6ADDB
    Displayable Message.........PCI Ethernet Adapter (23100020)
    Device Specific.(YL)........P1/E2

    proc0 P1-C1 Processor

    Device Specific.(YL)........P1-C1

    proc1 P1-C2 Processor

    Device Specific.(YL)........P1-C2


    PLATFORM SPECIFIC

    Name: IBM,7028-6C1
    Model: IBM,7028-6C1
    Node: /
    Device Type: chrp

    Processor Card:
    Part Number.................09P5254
    EC Level....................H11576
    Serial Number...............L081319061
    FRU Number..................09P3666
    Manufacture ID..............1980
    Version.....................RS6K
    Product Specific.
    (ZC).......PS=00165A0BC0,LB=000EE6B280,SB=00059682 F0,

    NP=01,L2=04096,PF=754,SV=3,VR=6,ER=00
    Product Specific.
    (ZB).......BC=90Z01,SG=000000491122334455667788
    Product Specific.
    (ZB).......BC=93Z02,SG=000000490001020304050607080 90A
    0B0C0D0E0F
    System Info Specific.(YL)...P1-C1
    Physical Location: P1-C1

    Processor Card:
    Part Number.................09P5254
    EC Level....................H11576
    Serial Number...............L081319009
    FRU Number..................09P3666
    Manufacture ID..............1980
    Version.....................RS6K
    Product Specific.
    (ZC).......PS=00165A0BC0,LB=000EE6B280,SB=00059682 F0,

    NP=01,L2=04096,PF=754,SV=3,VR=6,ER=00
    Product Specific.
    (ZB).......BC=90Z01,SG=000000491122334455667788
    Product Specific.
    (ZB).......BC=93Z02,SG=000000490001020304050607080 90A
    0B0C0D0E0F
    System Info Specific.(YL)...P1-C2
    Physical Location: P1-C2

    MEMORY CARD:
    Part Number.................09P3640
    EC Level....................H10862
    Serial Number...............12211CP0BB
    FRU Number..................09P2890
    Manufacture ID..............053
    Version.....................RS6K
    Product Specific.
    (ZM).......CL=4,VR=2,DE=2,EM=010002020910101203040 406

    111412160508060A1318141A070C080E151C161E
    System Info Specific.(YL)...P1-M1
    Physical Location: P1-M1

    System Planar:
    Part Number.................09P5281
    EC Level....................H11579
    Serial Number...............L092030355
    FRU Number..................09P2420
    Manufacture ID..............1980
    Version.....................RS6K
    Product Specific.
    (ZM).......MF=4,CL=4,VR=2,ES=8,EM=01F001F001F001F0 01F
    001F001F001F0
    Product Specific.(ZB).......BC=10Z01,SG=E20110499410AE50
    Product Specific.(ZB).......BC=10Z01,SG=B20120497A6AF751
    Product Specific.(ZB).......BC=10601,SG=A2013049632B1985
    System Info Specific.(YL)...P1
    Physical Location: P1

    System VPD:
    Machine/Cabinet Serial No...6500D7A
    Machine Type/Model..........7028-6C1
    Manufacture ID..............1980
    Version.....................RS6K
    System Info Specific.(YL)...L1-N1
    Physical Location: L1-N1

    Op Panel:
    Part Number.................21P6820
    EC Level....................F74746
    Serial Number...............1022007382
    FRU Number..................21P6820
    Manufacture ID..............39801424661
    Version.....................RS6K
    System Info Specific.(YL)...L1
    Physical Location: L1

    Power Supply:
    Part Number.................24P6867
    EC Level....................000000
    Serial Number...............J1J7U282160
    FRU Number..................36L8819
    Manufacture ID..............3980DELT
    Version.....................RS6K
    System Info Specific.(YL)...P3
    Physical Location: P3-V1

    Power Supply:
    Part Number.................24P6867
    EC Level....................000000
    Serial Number...............J1J7U28215Z
    FRU Number..................36L8819
    Manufacture ID..............3980DELT
    Version.....................RS6K
    System Info Specific.(YL)...P3
    Physical Location: P3-V2

    Power Backplane:
    Part Number.................21P7483
    EC Level....................000000
    Serial Number...............503147L1121S
    FRU Number..................53P0883
    Manufacture ID..............3980SMTC
    Version.....................RS6K
    System Info Specific.(YL)...P3
    Physical Location: P3

    SCSI Backplane:
    Part Number.................19K1084
    EC Level....................H21885
    Serial Number...............0000000000
    FRU Number..................21P9719
    Manufacture ID..............39801977725
    Version.....................RS6K
    System Info Specific.(YL)...P2
    Physical Location: P2

    Name: memory-controller
    Model: IBM, Racer/Whip, Rev-id 4.2
    Node: memory-controller@ff001000
    Physical Location: P1

    Name: nvram
    Node: nvram@ff800000
    Physical Location: P1

    Name: IBM,sp
    Node: IBM,sp@ff880000
    Physical Location: P1

    Service Processor Firmware:
    ROM Level (alterable).......ct030605
    Version.....................RS6K
    System Info Specific.(YL)...P1/Y2

    Name: rom
    Model: AM29F040-PLCC
    Node: rom@fff00000
    Physical Location: P1

    System Firmware:
    ROM Level (alterable).......CLT03156
    Version.....................RS6K
    System Info Specific.(YL)...P1/Y1

    Name: interrupt-controller
    Model: IBM, Racer/Whip, Open-PIC, 00
    Node: interrupt-controller@ffc00000
    Device Type: open-pic
    Physical Location: P1

    Name: openprom
    Model: IBM,CLT03156
    Node: openprom

    Name: pci
    Model: IBM, Python, Rev-id 3.0
    Node: pci@fef00000
    Physical Location: P1

    Name: pci
    Model: IBM, Python, Rev-id 3.0
    Node: pci@fee00000
    Physical Location: P1

    Name: PowerPC,POWER3
    Node: PowerPC,POWER3@0
    Device Type: cpu
    Physical Location: P1-C1

    Name: PowerPC,POWER3
    Node: PowerPC,POWER3@1
    Device Type: cpu
    Physical Location: P1-C2

    Name: IBM,memory-module
    Node: IBM,memory-module@0
    Physical Location: P1-M1.1

    Memory DIMM:
    Part Number.................09P1910
    Manufacture ID..............190F
    EC Level....................3131
    Serial Number...............02119
    Version.....................RS6K
    Size........................512
    Product Specific.
    (ZM).......JI=8008040d0b014800f1a07002f00404018f04 060

    101000ed0700000181418328000000000000000000

    000000000000000000000000000000000000000000

    002ca,JM=a400000000000000,JL=53,JP=3039503

    13931302020202020202020202020,JD=8000
    System Info Specific.(YL)...P1-M1.1

    Name: IBM,memory-module
    Node: IBM,memory-module@1
    Physical Location: P1-M1.2

    Memory DIMM:
    Part Number.................09P1910
    Manufacture ID..............190F
    EC Level....................3131
    Serial Number...............02119
    Version.....................RS6K
    Size........................512
    Product Specific.
    (ZM).......JI=8008040d0b014800f1a07002f00404018f04 060

    101000ed0700000181418328000000000000000000

    000000000000000000000000000000000000000000

    002ca,JM=a400000000000000,JL=53,JP=3039503

    13931302020202020202020202020,JD=8100
    System Info Specific.(YL)...P1-M1.2

    Name: IBM,memory-module
    Node: IBM,memory-module@4
    Physical Location: P1-M1.3

    Memory DIMM:
    Part Number.................09P1910
    Manufacture ID..............190F
    EC Level....................3131
    Serial Number...............02119
    Version.....................RS6K
    Size........................512
    Product Specific.
    (ZM).......JI=8008040d0b014800f1a07002f00404018f04 060

    101000ed0700000181418328000000000000000000

    000000000000000000000000000000000000000000

    002ca,JM=a400000000000000,JL=53,JP=3039503

    13931302020202020202020202020,JD=8400
    System Info Specific.(YL)...P1-M1.3

    Name: IBM,memory-module
    Node: IBM,memory-module@5
    Physical Location: P1-M1.4

    Memory DIMM:
    Part Number.................09P1910
    Manufacture ID..............190F
    EC Level....................3131
    Serial Number...............02119
    Version.....................RS6K
    Size........................512
    Product Specific.
    (ZM).......JI=8008040d0b014800f1a07002f00404018f04 060

    101000ed0700000181418328000000000000000000

    000000000000000000000000000000000000000000

    002ca,JM=a400000000000000,JL=53,JP=3039503

    13931302020202020202020202020,JD=8500
    System Info Specific.(YL)...P1-M1.4

    Name: IBM,memory-module
    Node: IBM,memory-module@8
    Physical Location: P1-M1.5

    Memory DIMM:
    Part Number.................09P1910
    Manufacture ID..............190F
    EC Level....................3131
    Serial Number...............02119
    Version.....................RS6K
    Size........................512
    Product Specific.
    (ZM).......JI=8008040d0b014800f1a07002f00404018f04 060

    101000ed0700000181418328000000000000000000

    000000000000000000000000000000000000000000

    002ca,JM=a400000000000000,JL=53,JP=3039503

    13931302020202020202020202020,JD=8800
    System Info Specific.(YL)...P1-M1.5

    Name: IBM,memory-module
    Node: IBM,memory-module@9
    Physical Location: P1-M1.6

    Memory DIMM:
    Part Number.................09P1910
    Manufacture ID..............190F
    EC Level....................3131
    Serial Number...............02119
    Version.....................RS6K
    Size........................512
    Product Specific.
    (ZM).......JI=8008040d0b014800f1a07002f00404018f04 060

    101000ed0700000181418328000000000000000000

    000000000000000000000000000000000000000000

    002ca,JM=a400000000000000,JL=53,JP=3039503

    13931302020202020202020202020,JD=8900
    System Info Specific.(YL)...P1-M1.6

    Name: IBM,memory-module
    Node: IBM,memory-module@c
    Physical Location: P1-M1.7

    Memory DIMM:
    Part Number.................09P1910
    Manufacture ID..............190F
    EC Level....................3131
    Serial Number...............02119
    Version.....................RS6K
    Size........................512
    Product Specific.
    (ZM).......JI=8008040d0b014800f1a07002f00404018f04 060

    101000ed0700000181418328000000000000000000

    000000000000000000000000000000000000000000

    002ca,JM=a400000000000000,JL=53,JP=3039503

    13931302020202020202020202020,JD=8c00
    System Info Specific.(YL)...P1-M1.7

    Name: IBM,memory-module
    Node: IBM,memory-module@d
    Physical Location: P1-M1.8

    Memory DIMM:
    Part Number.................09P1910
    Manufacture ID..............190F
    EC Level....................3131
    Serial Number...............02119
    Version.....................RS6K
    Size........................512
    Product Specific.
    (ZM).......JI=8008040d0b014800f1a07002f00404018f04 060

    101000ed0700000181418328000000000000000000

    000000000000000000000000000000000000000000

    002ca,JM=a400000000000000,JL=53,JP=3039503

    13931302020202020202020202020,JD=8d00
    System Info Specific.(YL)...P1-M1.8

    Name: isa
    Model: WINB,W83C553
    Node: isa@b
    Physical Location: P1

    Name: ide
    Node: ide@b,1
    Physical Location: P1/Q1

    Name: scsi
    Node: scsi@c
    Device Type: scsi-2
    Physical Location: P1/Z1

    Name: scsi
    Node: scsi@c,1
    Device Type: scsi-2
    Physical Location: P1/Z2

    Name: scsi
    Node: scsi@f
    Device Type: scsi-2
    Physical Location: P1-I5/Z1

    Name: ethernet
    Model: AMD,am79C971
    Node: ethernet@10
    Device Type: network
    Physical Location: P1/E1

    Name: ethernet
    Model: AMD,am79C971
    Node: ethernet@11
    Device Type: network
    Physical Location: P1/E2

    Name: raid
    Node: raid@b
    Physical Location: P1-I1/Q1

    Name: pci
    Node: pci@c
    Physical Location: P1-I2

    Name: l2-cache
    Node: l2-cache
    Device Type: cache
    Physical Location: P1-C1

    Name: l2-cache
    Node: l2-cache
    Device Type: cache
    Physical Location: P1-C2

    Name: rtc
    Node: rtc@i70
    Physical Location: P1

    Name: parallel
    Node: parallel@i378
    Physical Location: P1/R1

    Name: serial
    Node: serial@i3f8
    Physical Location: P1/S1

    Name: serial
    Node: serial@i2f8
    Physical Location: P1/S2

    Name: serial
    Node: serial@i898
    Physical Location: P1/S3

    Name: 8042
    Node: 8042@i60
    Physical Location: P1/K1

    Name: fdc
    Model: National,PC97307
    Node: fdc@i3f0
    Physical Location: P1/D1

    Name: timer
    Model: WINB,W83C553
    Node: timer@i40
    Device Type: IBM,timer
    Physical Location: P1

    Name: interrupt-controller
    Model: WINB,W83C553
    Node: interrupt-controller@i20
    Physical Location: P1

    Name: dma-controller
    Model: WINB,W83C553
    Node: dma-controller@i0
    Physical Location: P1

    Name: display
    Node: display@0
    Physical Location: P1-I2/G1

    GXT135P 2D Graphics Adapter:
    EC Level....................H10975B
    FRU Number..................09P5074
    Manufacture ID..............MATROX
    Part Number.................09P5074
    Version.....................RS6K

    Name: disk
    Node: disk@0
    Device Type: block
    Physical Location: P1-D1

  4. Re: audit

    On Dec 1, 9:07 am, News wrote:
    > Hi !
    >
    > I'm charged of auditing AIX machine to prove that AIX machine doesn't
    > handle such huge Oracle appli database. This is in order to convince
    > the client to replace it.
    >
    > What things must I look for ? except disk capacity and Oracle
    > performance that are done


    You're charged with auditing, you should know what to do. People
    charge
    $100s/hr for this type of job. Good luck pal!

  5. Re: audit

    News wrote:
    > Hi !
    >
    > I'm charged of auditing AIX machine to prove that AIX machine doesn't
    > handle such huge Oracle appli database. This is in order to convince
    > the client to replace it.


    In this case you have to do nothing at all:
    the client already knows what they want,
    so you only write a paper saying
    'Yes, you are right'.

  6. Re: audit

    On Dec 2, 3:07 am, News wrote:
    > Hi !
    >
    > I'm charged of auditing AIX machine to prove that AIX machine doesn't
    > handle such huge Oracle appli database. This is in order to convince
    > the client to replace it.
    >
    > What things must I look for ? except disk capacity and Oracle
    > performance that are done


    If you're running < 5.3.6 (I think) you can run a IBM developed
    feature called "aixpert", otherwise, roll your own.

  7. Re: audit

    On Dec 1, 9:07 am, News wrote:
    > Hi !
    >
    > I'm charged of auditing AIX machine to prove that AIX machine doesn't
    > handle such huge Oracle appli database. This is in order to convince
    > the client to replace it.
    >
    > What things must I look for ? except disk capacity and Oracle
    > performance that are done


    It sounds like you've already decided what the right answer is so I
    guess you're working backwards. It strikes me that there are 2 ways to
    do this: benchmarking or "magic numbers". Benchmarking would be to
    load the Oracle app onto the machine, start it up and let the client
    see how badly it runs. Failing that you need to find some
    authoritative source that says your workload requires thus-and-so-many
    TPC's or SPECMARKS or Rperf's or what-have-you and the machine has a
    lot less than that. Pick your authority and your magic number.

    HTH

    Jim Lane

+ Reply to Thread