Hello!

The issue got resolved after Support provided the new libbms.sl, nsrsybcc,
nsrsybrc, nsrsybsv files. Thought, this might be of some use to anyone here.

Thanks!
Shyam



On 3/20/08, Shyam Hegde <hegde.shyam AT gmail DOT com> wrote:
>
> Hello List,
>
> Is there anybody using NetWorker Module for Sybase in environment
> mentioned below please? Need your help!
>
> NetWorker Server 7.4SP1 on AIX operating system (32-bit) version 5.3
> NetWorker Storage Node/client 7.4 AIX operating system (32-bit) version
> 5.3
> Sybase ASE server (32-bit) software version 15.0
>
>
> When we run nsrsyb script with root logon or scheduled backup from backup
> server GUI, it throws following error.
>
> /usr/bin>nsrsyb3 -vvvv -U sybase -P sybase SYBASE:/CBSUATDB01/testdb
> Backing up database testdb.
> 24146:nsrsybsv:Error from server CBSUATDB01_BS: Msg 412402, Level 2, State
> 1
>         Backup Server: 4.124.2.1: Archive API error for device='bms::
> cbssrv1.CBSUATDB01.testdb*../sybase/tmp/syQTan7a*::00': Vendor application
> name=EMC, Library version=200, API routine=syb_open(), Message=unable to
> create environment variables.
>
> 24146:nsrsybsv:Error from server CBSUATDB01: Msg 8009, Level 16, State 1
>         Error encountered by Backup Server.  Please refer to Backup Server
> messages for details.
> 24115:nsrsybsv:Error: unable to dump database testdb in instance
> CBSUATDB01.
> nsrsybsv returned status of 1
> /usr/bin/nsrsyb3 exiting.
> /usr/bin>
>
> Here, when we run savegrp, it calls nsrsyb script as root logon. The
> Sybase ASE is running with sybase user logon.
> When I further investigated, the temporary file nsrsyb script creates (to
> transfer variable to ASE) on path mentioned in NSR_TEMPDIRE variable
> (/sybase/tmp in this case which has 777) has permissions -rw------- that
> means no other user i.e. sybase user in whose logon Sybase ASE is running
> is able to read, hence the backup fails to complete.
>
> To support the above threory, when I ran nsrsyb script as sybase user,
> backup completes with error. When I run nsrsyb script with sybase user
> logon, the temp file is created and read by the same user ID and hence no
> permission issue.
>
> Setting the umask to 022 and 002 also did not help.
>
> If nsrsybsv can create the temp file which has read permission for other
> users, it solves the problem. But so far I could not find a way.
>
> Thanks in advance !
>
> Shyam
>
>
>
>
>

To sign off this list, send email to listserv AT listserv.temple DOT edu and 
type "signoff networker" in the body of the email. Please write to 
networker-request AT listserv.temple DOT edu if you have any problems with this 
list. You can access the archives at 
http://listserv.temple.edu/archives/networker.html or
via RSS at http://listserv.temple.edu/cgi-bin/wa?RSS&L=NETWORKER