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?
Hi, Rolf,
I think I must confuse you because of the ncompatible results. I found I put a line of CONN to connect to sybase and gave all the parameters to CONN, so the result of sp_dbmon showed out. Now I remove the line out and the result only leaves "red Wed Nov 30 11:34:24 CST 2005 : Login Failed!: Login Failed!". I feel bb-sybase_ase.sh doesn't get parameters from the config files. When I go into the debug mode now, the last lines of the output are:
print "%1! %2! %3! %4! %5! %6! %7! %8! %9!",@blk,@conn,@maxcon,@locks,@runnable,@tlock,@cpu,@io,@idle
go
go
CONN=0 5 25 0 1 0 0.17 0.00 99.83
+ [ 0 = 0 ]
MONITORLINE=sybase92 Usage: CPU: % io: % idle: % block: conn: locks: runnable: table locks:
+ [ != 0 ]
./bb-sybase_ase.sh.teng: test: argument expected
That's all.
Regards,
Xiaoling Teng
----- Original Message -----
From: "Xiaoling Teng" <teng@pku.edu.cn>
To: <bb@bb4.com>
Sent: Wednesday, November 30, 2005 10:35 AM
Subject: 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.
>
--
=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-==-=-=-=-=-=-=-=-=-=-=-=
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