Re: {bb} Did anyone use bb-sybase_ase1.2?

[Xiaoling Teng <teng@pku.edu.cn>]

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.