After computer room power failure 3800 running sybase running appreciable slower.

After computer room power failure 3800 running sybase running appreciable slower.

Post by Ray Kinn » Wed, 24 Nov 2004 01:23:35



We have a sun 3800 Solaris 8, running sybase 12.5. T3 disk arrays.
I am seeing no errors in /var/adm/messages or /var/log/syslog.
Where can I look?
System Configuration:  Sun Microsystems  sun4u Sun Fire 3800
System clock frequency: 150 MHz
Memory size: 16384 Megabytes

========================= CPUs
===============================================

            Port  Run    E$   CPU      CPU
FRU Name     ID   MHz    MB   Impl.    Mask
----------  ----  ----  ----  -------  ----
/N0/SB0/P0    0    900   8.0  US-III+  2.2
/N0/SB0/P1    1    900   8.0  US-III+  2.2
/N0/SB0/P2    2    900   8.0  US-III+  2.2FRU Name        ID   Num    
 Size     Status       Size    Factor      Segment
-------------  ----  ----     ------   -----------  ------  ----------
 --------
--
/N0/SB0/P0/B0    0    0       512MB    pass          256MB    16-way  
    0
/N0/SB0/P0/B1    0    1       512MB    pass          256MB    16-way  
    0
/N0/SB0/P0/B0    0    2       512MB    pass          256MB    16-way  
    0
/N0/SB0/P0/B1    0    3       512MB    pass          256MB    16-way  
    0
/N0/SB0/P1/B0    1    0       512MB    pass          256MB    16-way  
    0
/N0/SB0/P1/B1    1    1       512MB    pass          256MB    16-way  
    0
/N0/SB0/P1/B0    1    2       512MB    pass          256MB    16-way  
    0
/N0/SB0/P1/B1    1    3       512MB    pass          256MB    16-way  
    0
/N0/SB0/P2/B0    2    0       512MB    pass          256MB    16-way  
    0
/N0/SB0/P2/B1    2    1       512MB    pass          256MB    16-way  
    0
/N0/SB0/P2/B0    2    2       512MB    pass          256MB    16-way  
    0
/N0/SB0/P2/B1    2    3       512MB    pass          256MB    16-way  
    0
/N0/SB0/P3/B0    3    0       512MB    pass          256MB    16-way  
    0
/N0/SB0/P3/B1    3    1       512MB    pass          256MB    16-way  
    0
/N0/SB0/P3/B0    3    2       512MB    pass          256MB    16-way  
    0
/N0/SB0/P3/B1    3    3       512MB    pass          256MB    16-way  
    0
/N0/SB2/P0/B0    8    0       512MB    pass          256MB    16-way  
    1
/N0/SB2/P0/B1    8    1       512MB    pass          256MB    16-way  
    1
/N0/SB2/P0/B0    8    2       512MB    pass          256MB    16-way  
    1
/N0/SB2/P0/B1    8    3       512MB    pass          256MB    16-way  
    1
/N0/SB2/P1/B0    9    0       512MB    pass          256MB    16-way  
    1
/N0/SB2/P1/B1    9    1       512MB    pass          256MB    16-way  
    1
/N0/SB2/P1/B0    9    2       512MB    pass          256MB    16-way  
    1
/N0/SB2/P1/B1    9    3       512MB    pass          256MB    16-way  
    1
/N0/SB2/P2/B0   10    0       512MB    pass          256MB    16-way  
    1
/N0/SB2/P2/B1   10    1       512MB    pass          256MB    16-way  
    1
/N0/SB2/P2/B0   10    2       512MB    pass          256MB    16-way  
    1
/N0/SB2/P2/B1   10    3       512MB    pass          256MB    16-way  
    1
/N0/SB2/P3/B0   11    0       512MB    pass          256MB    16-way  
    1
/N0/SB2/P3/B1   11    1       512MB    pass          256MB    16-way  
    1
/N0/SB2/P3/B0   11    2       512MB    pass          256MB    16-way  
    1
/N0/SB2/P3/B1   11    3       512MB    pass          256MB    16-way  
    1

========================= IO Cards =========================

                                Bus  Max

            IO   Port Bus       Freq Bus  Dev,

FRU Name    Type  ID  Side Slot MHz  Freq Func State Name
       Model
----------  ---- ---- ---- ---- ---- ---- ---- -----
---------------------------
-----  ----------------------
/N0/IB6/P0  cPCI  24   B    2    33   33  1,0  ok  
pci-pci1011,46.1/pci108e,10
00     pci-bridge
/N0/IB6/P0  cPCI  24   B    2    33   33  0,0  ok  
pci108e,1000-pci108e,1000.1

/N0/IB6/P0  cPCI  24   B    2    33   33  0,1  ok  
SUNW,hme-pci108e,1001
       SUNW,cheerio
/N0/IB6/P0  cPCI  24   B    2    33   33  4,0  ok  
SUNW,isptwo-pci1077,1020/sd
 (blo+ QLGC,ISP1040B
/N0/IB6/P0  cPCI  24   B    3    33   33  2,0  ok  
pci-pci1011,46.1/SUNW,qlc (
scsi-+ pci-bridge
/N0/IB6/P0  cPCI  24   B    3    33   33  4,0  ok  
SUNW,qlc-pci1077,2200.1077.
4084.+
/N0/IB6/P0  cPCI  24   B    3    33   33  5,0  ok  
SUNW,qlc-pci1077,2200.1077.
4084.+
/N0/IB6/P1  cPCI  25   B    4    33   33  1,0  ok  
pci-pci1011,46.1/pci108e,10
00     pci-bridge
/N0/IB6/P1  cPCI  25   B    4    33   33  0,0  ok  
pci108e,1000-pci108e,1000.1

/N0/IB6/P1  cPCI  25   B    4    33   33  0,1  ok  
SUNW,hme-pci108e,1001
          SUNW,cheerio
/N0/IB6/P1  cPCI  25   B    4    33   33  4,0  ok  
SUNW,isptwo-pci1077,1020/sd
 (blo+ QLGC,ISP1040B
/N0/IB8/P0  cPCI  28   B    2    33   33  1,0  ok  
pci-pci1011,46.1/SUNW,isptw
o (sc+ pci-bridge
/N0/IB8/P0  cPCI  28   B    2    33   33  4,0  ok  
SUNW,isptwo-pci1077,1020/sd
 (blo+ QLGC,ISP1040B
/N0/IB8/P0  cPCI  28   B    2    33   33  5,0  ok  
SUNW,isptwo-pci1077,1020/sd
 (blo+ QLGC,ISP1040B
/N0/IB8/P0  cPCI  28   B    3    33   33  2,0  ok  
pci-pci1011,46.1/SUNW,qlc (
scsi-+ pci-bridge
/N0/IB8/P0  cPCI  28   B    3    33   33  4,0  ok  
SUNW,qlc-pci1077,2200.1077.
4084.+
/N0/IB8/P0  cPCI  28   B    3    33   33  5,0  ok  
SUNW,qlc-pci1077,2200.1077.
4084.+
/N0/IB8/P1  cPCI  29   B    4    33   33  1,0  ok  
pci-pci1011,46.1/pci108e,10
00     pci-bridge
/N0/IB8/P1  cPCI  29   B    4    33   33  0,0  ok  
pci108e,1000-pci108e,1000.1

/N0/IB8/P1  cPCI  29   B    4    33   33  0,1  ok  
SUNW,qfe-pci108e,1001
       SUNW,cpci-qfe
/N0/IB8/P1  cPCI  29   B    4    33   33  1,0  ok  
pci108e,1000-pci108e,1000.1

/N0/IB8/P1  cPCI  29   B    4    33   33  1,1  ok  
SUNW,qfe-pci108e,1001
       SUNW,cpci-qfe
/N0/IB8/P1  cPCI  29   B    4    33   33  2,0  ok  
pci108e,1000-pci108e,1000.1

/N0/IB8/P1  cPCI  29   B    4    33   33  2,1  ok  
SUNW,qfe-pci108e,1001
       SUNW,cpci-qfe
/N0/IB8/P1  cPCI  29   B    4    33   33  3,0  ok  
pci108e,1000-pci108e,1000.1

/N0/IB8/P1  cPCI  29   B    4    33   33  3,1  ok  
SUNW,qfe-pci108e,1001
       SUNW,cpci-qfe

========================= Active Boards for Domain
===========================

          Power  Fault  HotPlug  Board
FRU Name   LED    LED     LED    Cond.
--------  -----  -----  -------  -------
/N0/SB0   on     off    off      ok
/N0/SB2   on     off    off      ok
/N0/IB6   on     off    off      ok
/N0/IB8   on     off    off      ok
========================= Available Boards/Slots for Domain
==================

          Power  Fault  HotPlug  Board/Slot  Board/Slot
FRU Name   LED    LED     LED    Condition   Assigned
--------  -----  -----  -------  ----------  ----------
There are currently no Boards/Slots available to this Domain

========================= Hardware Failures
==================================
No Hardware failures found in System

========================= HW Revisions
=======================================

System PROM revisions:
----------------------
OBP 5.12.6 11/29/01 12:41

IO ASIC revisions:
------------------
                          Port
FRU Name    Model            ID  Status Version
----------- --------------- ---- ------ -------
/N0/IB6/P0  SUNW,schizo      24   ok     4/N0/IB6/P1  SUNW,schizo    
25   ok     4
/N0/IB8/P0  SUNW,schizo      28   ok     4
/N0/IB8/P1  SUNW,schizo      29   ok     4
/N0/IB6/P0  SUNW,sgsbbc      24   ok     2
/N0/IB8/P0  SUNW,sgsbbc      28   ok     2

/N0/SB0/P3    3    900   8.0  US-III+  2.2
/N0/SB2/P0    8    900   8.0  US-III+  2.2
/N0/SB2/P1    9    900   8.0  US-III+  2.2
/N0/SB2/P2   10    900   8.0  US-III+  2.2
/N0/SB2/P3   11    900   8.0  US-III+  2.2

========================= Memory Configuration
===============================

                     Logical  Logical  Logical
               Port  Bank     Bank     Bank         DIMM    Interleave
Interlea

 
 
 

After computer room power failure 3800 running sybase running appreciable slower.

Post by Michael Tos » Wed, 24 Nov 2004 01:40:11



Quote:> We have a sun 3800 Solaris 8, running sybase 12.5. T3 disk arrays.
> I am seeing no errors in /var/adm/messages or /var/log/syslog.
> Where can I look?
> System Configuration:  Sun Microsystems  sun4u Sun Fire 3800
> System clock frequency: 150 MHz
> Memory size: 16384 Megabytes

...

You mean DB requests take significantly longer.

Probably your DB disks are slow, check with iostat.
After some time most of the freqently used data will be in memory again.

--
Michael Tosch
IT Specialist
HP Managed Services
Technology Solutions Group
Hewlett-Packard GmbH
Phone: +49 2407 575 313
Mail: michael.tosch:hp.com

 
 
 

After computer room power failure 3800 running sybase running appreciable slower.

Post by Bart Smaalde » Wed, 24 Nov 2004 16:52:56




> > We have a sun 3800 Solaris 8, running sybase 12.5. T3 disk arrays.
> > I am seeing no errors in /var/adm/messages or /var/log/syslog.
> > Where can I look?
> > System Configuration:  Sun Microsystems  sun4u Sun Fire 3800
> > System clock frequency: 150 MHz
> > Memory size: 16384 Megabytes
> ...

> You mean DB requests take significantly longer.

> Probably your DB disks are slow, check with iostat.
> After some time most of the freqently used data will be in memory again.

Check your hardware.  Do you have the same number of cpus? RAM?
The hardware will automatically unconfig broken bits out of the way
and boot w/ the remainder.  Can be confusing if you're missing something
and you don't notice...

- Bart

 
 
 

After computer room power failure 3800 running sybase running appreciable slower.

Post by Zcor » Sat, 27 Nov 2004 13:01:04


We also use Sybase with T3 partner pairs for the databases. Whenever
we see major performance issues we take a closer look at the T3s. If
any component in the T3 partner pair, other than a failed disk, has a
problem the cache mode switches from write-behind to write-through.
This results in a least a ten fold increase in write times.

Command "vol mode" will return cahce settings.

If T3 FRUs are all good, check to see if the batteries have expired. I
thought we had an issue a while back that when the batteries expired
the cache mode switched to write-through mode. Also when the batterys
are replaced the system remains in write-through mode until the
batteries are fully charges (12 hours).

T3s used to ship with the batteries expiration set for two years. When
we recently requested replacement batteries we were informed that the
batteries were now good for three years and that we should reset the
date so the batteries would not exppire for another year.

Do not remember commands to check or reset battery date. Will be
office Monday and could review my notes if it would help.

 
 
 

1. telnet logins running slower and slower...

I have a linux server running Redhat 6.1 and it has been up for about a year
now.  I'm having a problem with telnet.  When someone telnets to the server,
it connects right away, but takes 20 seconds or so for the login prompt to
be displayed.  Any suggestions on how to solve this problem or where to
start?

2. Proxy server on aliased IP

3. aix 3.2 - see sed run, run sed run

4. changing a user's NIS passwd as root. How?

5. Installation/Running GeForce2 Linux EMERGENCY, FAILURE AFTER FAILURE

6. kstat programming

7. Tracking Down a Computer Power Failure

8. Linksys wireless

9. Dealing with power failures and building a new computer

10. root '/' running out of room

11. I ran outa room! help!

12. how do I not run out of room with buildworld?

13. What do I do when I run out of room in /etc/group?