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.