BB Unix Network Monitor - Message
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: {bb} Did anyone use bb-sybase_ase1.2?
Thanks Rolf.
I checked the debug output, it shows out the below message:
====================
<sniped>
select @conn=count(*) from master..sysprocesses where suid>1
select @blk=count(*) from master..sysprocesses where blocked!=0
select @locks=count(*) from master..syslocks
select @runnable=count(*) from master..sysprocesses where cmd!="AWAITING COMMAND" and suid>1
select @tlock=count(*) from master..syslocks where type=1
select @maxcon = c.value2 from master..syscurconfigs c, master..sysconfigures s
where c.config = s.config
and s.name ='number of user connections'
select @ms_per_tick = convert(int,@@timeticks/1000)
select
@lc = ( @@cpu_busy * @ms_per_tick) / 1000 ,
@li = ( @@io_busy * @ms_per_tick) / 1000 ,
@lidle = ( @@idle * @ms_per_tick) / 1000
select @sumtimes = @lc + @li + @lidle
if @sumtimes=0
select @sumtimes=1,@lc=1,@li=0,@lidle=0
select @cpu=str(convert(float,(100*@lc))/@sumtimes,5,2)
select @io=str(convert(float,(100*@li))/@sumtimes,5,2)
select @idle=str(convert(float,(100*@lidle))/@sumtimes,5,2)
print "%1! %2! %3! %4! %5! %6! %7! %8! %9!",@blk,@conn,@maxcon,@locks,@runnable,@tlock,@cpu,@io,@idle
go
go
+ -Uguest -Pguest123 -Ssybase92
./bb-sybase_ase.sh: -Uguest: not found
+ [ 1 = 0 ]
+ set_color red
+ [ green = red ]
COLOR=red
LINE=sybase92: Login Failed!
+ dbspace
+ /export/home5/sybase92/bin/isql -U guest -P guest123 -Ssybase92
sp__dbmon
go
+ [ 0 = 0 ]
<sniped>
=============
Any suggestion?
Regards,
Xiaoling Teng
----- Original Message -----
From: "Rolf Schrittenlocher" <Schrittenlocher@rz.uni-frankfurt.de>
To: <bb@bb4.com>
Sent: Tuesday, November 29, 2005 3:50 PM
Subject: Re: {bb} Did anyone use bb-sybase_ase1.2?
> Hi Xiaoling,
>
> don't you send the full output of sp_dbmon to bb? I'd propose that! For
> debugging you might run the script as well with an "echo" in terminal
> mode instead of sending to BB. The message says that by running the
> script there was no login possible. Check that by adding debugging
> output in the script. the first and second message are incompatible, the
> second might result in "suboptimal" handling of the first event by
> bb-sybase_ase.
>
> regards
> Rolf
>
>>Thanks Rolf.
>>As you metioned, I checked bb-user and it didn't have the permission to run isql. Now the information of sp_dbmon shows out, but still reports something I feel quite strange:
>>"red Tue Nov 29 10:22:15 CST 2005 sybase92: Login Failed!: Space limit reached!"
>>Why "Login Failee"? if Login failed, how bb could show the sp_dbmon reports out?
>>Anyway, thanks again for your help.
>>Regards,
>>Xiaoling
>>----- Original Message -----
>>From: "Rolf Schrittenlocher" <Schrittenlocher@rz.uni-frankfurt.de>
>>To: <bb@bb4.com>
>>Sent: Friday, November 25, 2005 4:54 PM
>>Subject: Re: {bb} Did anyone use bb-sybase_ase1.2?
>>
>>
>>
>>
>>>Hi Xiaoling,
>>>
>>>it seems to me that you are getting a message from sybase but not the
>>>expected one. So everything on bb-side might be ok. can you execute the
>>>isql/sqsh command as bb-user by hand?
>>>We are running 1.9c so I know not much about newer versions.
>>>
>>>regards
>>>Rolf
>>>
>>>
>>>
>>>>Thanks Rolf.
>>>>
>>>>I run the sp__dbmon, and the output is right.
>>>>I found the etc/bb-exttab doesn't work, bb still reads the file etc/bb-bbexttab, not etc/bb-exttab. I use bbc1.9h-btf . Is it because the version is too new to use extdef module ? Now the output becomes as this:
>>>>
>>>>purple Fri Nov 25 15:16:51 CST 2005 sybase92: backupserver binary missing! : dataserver binary missing!
>>>>backupserver binary missing!
>>>>dataserver binary missing!
>>>>Any suggestion?====Regards,Xiaoling Teng
>>>>
>>>>----- Original Message -----
>>>>From: "Rolf Schrittenlocher" <Schrittenlocher@rz.uni-frankfurt.de>
>>>>To: <bb@bb4.com>
>>>>Sent: Friday, November 25, 2005 2:56 PM
>>>>Subject: Re: {bb} Did anyone use bb-sybase_ase1.2?
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>>Hi,
>>>>>
>>>>>is the output of sp_dbmon ok (check inside the database)? If here all
>>>>>informations wanted are displayed, check the script. If not, check
>>>>>sp_dbmon and its installation. Here is an example output of sp_dbmon
>>>>>(layout might be different to yours, I don't remember if we changed
>>>>>something):
>>>>>lbsdb.1> sp_dbmon
>>>>>lbsdb.2> go
>>>>>DB_name Seg_id Seg_name Size_MB Free_MB Percent_free
>>>>>----------------- ----------- ---------- --------- --------- ------------
>>>>>lbsdb 3 data 14336.00 2266.42 15.81
>>>>>lbsdb 4 log 1024.00 1021.54 99.76
>>>>>master 7 data & log 20.00 14.32 71.59
>>>>>model 7 data & log 4.00 2.64 65.97
>>>>>sybsystemdb 7 data & log 102.00 100.19 98.22
>>>>>sybsystemprocs 7 data & log 150.00 87.71 58.48
>>>>>tempdb 7 data & log 1026.00 1020.62 99.48
>>>>>
>>>>>(return status = 0)
>>>>>
>>>>>regards
>>>>>Rolf
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>>Thanks for your reply. I changed to use bb-sybase_ase1.1 and did the steps as README says. But the BB web only showed the below info:
>>>>>>
>>>>>>green Fri Nov 25 10:12:41 CST 2005 sybase92: Sybase OK
>>>>>>
>>>>>>
>>>>>>Errorlog:
>>>>>>I just wonder why so little information shows out,There must be something wrong. But I don't know where the problem is. Any ideas?Thanks,Xiaoling Teng
>>>>>>
>>>>>>
>>>>>>----- Original Message -----
>>>>>>From: "Rolf Schrittenlocher" <Schrittenlocher@rz.uni-frankfurt.de>
>>>>>>To: <bb@bb4.com>
>>>>>>Sent: Thursday, November 24, 2005 4:11 PM
>>>>>>Subject: Re: {bb} Did anyone use bb-sybase_ase1.2?
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>>>Hello,
>>>>>>>we use bb-sybase_ase1.1, not 1.2. You need sp_dbmon.sql to use it. It is
>>>>>>>a stored procedure inside the database which is started by
>>>>>>>bb-sybase_ase1.1, collects the database-info and gives the output to
>>>>>>>bb-sybase_ase1.1.
>>>>>>>
>>>>>>>kind regards
>>>>>>>Rolf
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>--
>>>Mit freundlichen Gruessen
>>>Rolf Schrittenlocher
>>>
>>>HRZ/BDV, Senckenberganlage 31, 60054 Frankfurt
>>>Tel: (49) 69 - 798 28908 Fax: (49) 69 798 2881
>>>LBS: lbs-f@mlist.uni-frankfurt.de
>>>Persoenlich: schritte@rz.uni-frankfurt.de
>>>
>>>
>>>--
>>>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
>>>To unsubscribe from this list, or to subscribe to the bb-digest list
>>>send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
>>>subscribe bb-digest in the BODY of the message.
>>>
>>>
>>--
>>=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
>>To unsubscribe from this list, or to subscribe to the bb-digest list
>>send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
>>subscribe bb-digest in the BODY of the message.
>>
>>
>>
>
>
> --
> Mit freundlichen Gruessen
> Rolf Schrittenlocher
>
> HRZ/BDV, Senckenberganlage 31, 60054 Frankfurt
> Tel: (49) 69 - 798 28908 Fax: (49) 69 798 2881
> LBS: lbs-f@mlist.uni-frankfurt.de
> Persoenlich: schritte@rz.uni-frankfurt.de
>
>
> --
> =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
> To unsubscribe from this list, or to subscribe to the bb-digest list
> send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
> subscribe bb-digest in the BODY of the message.
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
To unsubscribe from this list, or to subscribe to the bb-digest list
send e-mail to mailto:majordomo@bb4.com with unsubscribe bb -and/or-
subscribe bb-digest in the BODY of the message.
Home |
Main Index |
Thread Index