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

[Rolf Schrittenlocher <Schrittenlocher@rz.uni-frankfurt.de>]

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.