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

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

Thanks Rolf.

I check the account and it didn't work well so we created another account. Now  the output is right in debug mode. 
But in normal mode, the output still reports " Login Failed".  I think I didn't put extdef.sh in right place. Because in debug mode, the extdef.sh is in bb-sybase_ase.sh.
README says extdef.sh should put in runbb.sh, but it didn't work well.  
Anyway, I am glad the things are progressing. Thanks again for your help.
Regards,
Xiaoling Teng
----- Original Message ----- 
From: "Rolf Schrittenlocher" <Schrittenlocher@rz.uni-frankfurt.de>
To: <bb@bb4.com>
Sent: Wednesday, November 30, 2005 3:33 PM
Subject: Re: {bb} Did anyone use bb-sybase_ase1.2?


> Hi Xiaoling,
> 
> you are right, I am confused. I have the imprssion that the login via 
> isql to your sybase server doesn't work. The lines
> 
> red Wed Nov 30 11:34:24 CST 2005 : Login Failed!
> and
> ./bb-sybase_ase.sh: -Uguest: not found (hope you've changed the password!)
> sufggest that.
> Check first if login into sybase is working at all by using something like
> isql -U$Sybusername -P$Sybpassword -S$Sybserver > /dev/null << End
> exit
> go
> End
> and then interpretating $?
> 
> regards 
> Rolf
> 
> 
>>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.
>>
>>  
>>
> 
> 
> -- 
> 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.