Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Install / Create ASE automatically

9 posts in Windows NT Last posting was on 2000-06-23 12:47:17.0Z
Peter Fopma Posted on 2000-06-19 15:06:24.0Z
Message-ID: <394E36F0.78D6FB91@labcontrol.com>
Date: Mon, 19 Jun 2000 17:06:24 +0200
From: Peter Fopma <pf@labcontrol.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Install / Create ASE automatically
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 24
NNTP-Posting-Host: pc027.labcontrol.com 195.82.85.155
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2010
Article PK: 1089471

I would like to find a method to automatically install ASE for NT and
automatically create a DB server from within an installation procedure.

I found posting with reference to the setup program and parameter -r.
But this
only seems to solve half the problem since the creation of the actual DB
server
is not carried out (at least not for me - or is this maybe an error due
to my messed
up installation?)
The sybase installation program seems to call syconfig - and to me it
seems
as if this program can be called with command line parameters (start
with
-i and the program immediately asks for the name of the server you wish
to
create...)
Does anybody know parameters for syconfig? Or has anybody tried to
create an installation using setup with the -r option?
Or, if there is a much easier way to do this, which I might have missed
scanning
through the postings, please let me know.

Thanks,
Peter Fopma


Peter Veilleux Posted on 2000-06-20 13:48:42.0Z
Message-ID: <394F763A.35BBDD8E@nvestservices.com>
Date: Tue, 20 Jun 2000 09:48:42 -0400
From: Peter Veilleux <pveilleux@nvestservices.com>
X-Mailer: Mozilla 4.72 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Install / Create ASE automatically
References: <394E36F0.78D6FB91@labcontrol.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 66
NNTP-Posting-Host: nefclient192.mutualfunds.com 206.136.227.192
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2002
Article PK: 1089449

Peter,

I've used resource files before and found it quite easy. Use one of the
sample resource files in $SYBASE/init/sample_resource_files. Don't know if
that's the same path on NT. Save the sample as whatever you are calling
your ASE and make the changes in there. Everything is pretty
straight-forward. Here is what the file looks like for 11.5.1 on UNIX:

nefprod2:sybase:$more srvbuild.adaptive_server.rs
sybinit.release_directory: USE_DEFAULT
sybinit.product: sqlsrv
sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE
sqlsrv.new_config: yes
sqlsrv.do_add_server: yes
sqlsrv.network_protocol_list: tcp
sqlsrv.network_hostname_list: PUT_YOUR_HOSTNAME_HERE
sqlsrv.network_port_list: PUT_YOUR_PORT_NUMBER_HERE
sqlsrv.master_device_physical_name: PUT_THE_PATH_OF_YOUR_MASTER_DEVICE_HERE
sqlsrv.master_device_size: USE_DEFAULT
sqlsrv.master_database_size: USE_DEFAULT
sqlsrv.errorlog: USE_DEFAULT
sqlsrv.do_upgrade: no
sqlsrv.sybsystemprocs_device_physical_name:
PUT_THE_PATH_OF_YOUR_SYBSYSTEMPROCS_DEVICE_HERE
sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
sqlsrv.sybsystemdb_device_physical_name:
PUT_THE_PATH_OF_YOUR_SYBSYSTEMDB_DEVICE_HERE_OR_REMOVE_THIS_LINE
sqlsrv.sybsystemdb_device_size: USE_DEFAULT
sqlsrv.sybsystemdb_database_size: USE_DEFAULT
sqlsrv.default_backup_server: PUT_YOUR_BACKUP_SERVER_NAME_HERE
nefprod2:sybase:$

I would recommend filling in as much as possible, even if it is the default
value. Unfortunately, I don't know much about syconfig without taking the
time to look at it.

Hope this helps....

Peter

Peter Fopma wrote:

> I would like to find a method to automatically install ASE for NT and
> automatically create a DB server from within an installation procedure.
>
> I found posting with reference to the setup program and parameter -r.
> But this
> only seems to solve half the problem since the creation of the actual DB
> server
> is not carried out (at least not for me - or is this maybe an error due
> to my messed
> up installation?)
> The sybase installation program seems to call syconfig - and to me it
> seems
> as if this program can be called with command line parameters (start
> with
> -i and the program immediately asks for the name of the server you wish
> to
> create...)
> Does anybody know parameters for syconfig? Or has anybody tried to
> create an installation using setup with the -r option?
> Or, if there is a much easier way to do this, which I might have missed
> scanning
> through the postings, please let me know.
>
> Thanks,
> Peter Fopma


Rob Verschoor Posted on 2000-06-20 17:48:34.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <394E36F0.78D6FB91@labcontrol.com> <394F763A.35BBDD8E@nvestservices.com>
Subject: Re: Install / Create ASE automatically
Date: Tue, 20 Jun 2000 19:48:34 +0200
Lines: 113
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <6l9AIMu2$GA.285@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i025.spy.euronet.nl 194.134.26.189
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1998
Article PK: 1089447

Unfortunately, you cannot use resource files on NT as you can on Unix.
On NT, your only option is to create a batch script (or better a shell
script using for example the CygWin shell emulator) which runs
bldmstr.exe to create the server, then creates sybsystemprocs using
isql and somehow adds the proper entires to the SQL.INI file.
It sounds more difficult than it is, depending on how advanced you
want your script to be.

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Associate DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl
WWW http://www.euronet.nl/~syp_rob
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

"Peter Veilleux" <pveilleux@nvestservices.com> wrote in message
news:394F763A.35BBDD8E@nvestservices.com...
> Peter,
>
> I've used resource files before and found it quite easy. Use one of
the
> sample resource files in $SYBASE/init/sample_resource_files. Don't
know if
> that's the same path on NT. Save the sample as whatever you are
calling
> your ASE and make the changes in there. Everything is pretty
> straight-forward. Here is what the file looks like for 11.5.1 on
UNIX:
>
> nefprod2:sybase:$more srvbuild.adaptive_server.rs
> sybinit.release_directory: USE_DEFAULT
> sybinit.product: sqlsrv
> sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE
> sqlsrv.new_config: yes
> sqlsrv.do_add_server: yes
> sqlsrv.network_protocol_list: tcp
> sqlsrv.network_hostname_list: PUT_YOUR_HOSTNAME_HERE
> sqlsrv.network_port_list: PUT_YOUR_PORT_NUMBER_HERE
> sqlsrv.master_device_physical_name:
PUT_THE_PATH_OF_YOUR_MASTER_DEVICE_HERE
> sqlsrv.master_device_size: USE_DEFAULT
> sqlsrv.master_database_size: USE_DEFAULT
> sqlsrv.errorlog: USE_DEFAULT
> sqlsrv.do_upgrade: no
> sqlsrv.sybsystemprocs_device_physical_name:
> PUT_THE_PATH_OF_YOUR_SYBSYSTEMPROCS_DEVICE_HERE
> sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
> sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
> sqlsrv.sybsystemdb_device_physical_name:
> PUT_THE_PATH_OF_YOUR_SYBSYSTEMDB_DEVICE_HERE_OR_REMOVE_THIS_LINE
> sqlsrv.sybsystemdb_device_size: USE_DEFAULT
> sqlsrv.sybsystemdb_database_size: USE_DEFAULT
> sqlsrv.default_backup_server: PUT_YOUR_BACKUP_SERVER_NAME_HERE
> nefprod2:sybase:$
>
> I would recommend filling in as much as possible, even if it is the
default
> value. Unfortunately, I don't know much about syconfig without
taking the
> time to look at it.
>
> Hope this helps....
>
> Peter
>
>
> Peter Fopma wrote:
>
> > I would like to find a method to automatically install ASE for NT
and
> > automatically create a DB server from within an installation
procedure.
> >
> > I found posting with reference to the setup program and
parameter -r.
> > But this
> > only seems to solve half the problem since the creation of the
actual DB
> > server
> > is not carried out (at least not for me - or is this maybe an
error due
> > to my messed
> > up installation?)
> > The sybase installation program seems to call syconfig - and to me
it
> > seems
> > as if this program can be called with command line parameters
(start
> > with
> > -i and the program immediately asks for the name of the server you
wish
> > to
> > create...)
> > Does anybody know parameters for syconfig? Or has anybody tried to
> > create an installation using setup with the -r option?
> > Or, if there is a much easier way to do this, which I might have
missed
> > scanning
> > through the postings, please let me know.
> >
> > Thanks,
> > Peter Fopma
>


Jerry Dennany Posted on 2000-06-21 02:11:09.0Z
From: "Jerry Dennany" <jerdenn@mindspring.com>
References: <394E36F0.78D6FB91@labcontrol.com> <394F763A.35BBDD8E@nvestservices.com> <6l9AIMu2$GA.285@forums.sybase.com>
Subject: Re: Install / Create ASE automatically
Date: Tue, 20 Jun 2000 22:11:09 -0400
Lines: 130
X-Newsreader: Microsoft Outlook Express 4.72.3110.1
X-MimeOLE: Produced By Microsoft MimeOLE V4.72.3110.3
Message-ID: <e6i2Way2$GA.285@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: user-38lc8r2.dialup.mindspring.com 209.86.35.98
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1994
Article PK: 1089444

Actually, Rob, Peter was correct, the Sybase install can be scripted on NT.

Take a look at the documentation for SYBATCH.exe .



Jerry Dennany
Installation Engineer
jerdenn@mindspring.com



Rob Verschoor wrote in message <6l9AIMu2$GA.285@forums.sybase.com>...
Unfortunately, you cannot use resource files on NT as you can on Unix.
On NT, your only option is to create a batch script (or better a shell
script using for example the CygWin shell emulator) which runs
bldmstr.exe to create the server, then creates sybsystemprocs using
isql and somehow adds the proper entires to the SQL.INI file.
It sounds more difficult than it is, depending on how advanced you
want your script to be.

HTH,

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Associate DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl
WWW http://www.euronet.nl/~syp_rob
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

"Peter Veilleux" <pveilleux@nvestservices.com> wrote in message
news:394F763A.35BBDD8E@nvestservices.com...
> Peter,
>
> I've used resource files before and found it quite easy. Use one of
the
> sample resource files in $SYBASE/init/sample_resource_files. Don't
know if
> that's the same path on NT. Save the sample as whatever you are
calling
> your ASE and make the changes in there. Everything is pretty
> straight-forward. Here is what the file looks like for 11.5.1 on
UNIX:
>
> nefprod2:sybase:$more srvbuild.adaptive_server.rs
> sybinit.release_directory: USE_DEFAULT
> sybinit.product: sqlsrv
> sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE
> sqlsrv.new_config: yes
> sqlsrv.do_add_server: yes
> sqlsrv.network_protocol_list: tcp
> sqlsrv.network_hostname_list: PUT_YOUR_HOSTNAME_HERE
> sqlsrv.network_port_list: PUT_YOUR_PORT_NUMBER_HERE
> sqlsrv.master_device_physical_name:
PUT_THE_PATH_OF_YOUR_MASTER_DEVICE_HERE
> sqlsrv.master_device_size: USE_DEFAULT
> sqlsrv.master_database_size: USE_DEFAULT
> sqlsrv.errorlog: USE_DEFAULT
> sqlsrv.do_upgrade: no
> sqlsrv.sybsystemprocs_device_physical_name:
> PUT_THE_PATH_OF_YOUR_SYBSYSTEMPROCS_DEVICE_HERE
> sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
> sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
> sqlsrv.sybsystemdb_device_physical_name:
> PUT_THE_PATH_OF_YOUR_SYBSYSTEMDB_DEVICE_HERE_OR_REMOVE_THIS_LINE
> sqlsrv.sybsystemdb_device_size: USE_DEFAULT
> sqlsrv.sybsystemdb_database_size: USE_DEFAULT
> sqlsrv.default_backup_server: PUT_YOUR_BACKUP_SERVER_NAME_HERE
> nefprod2:sybase:$
>
> I would recommend filling in as much as possible, even if it is the
default
> value. Unfortunately, I don't know much about syconfig without
taking the
> time to look at it.
>
> Hope this helps....
>
> Peter
>
>
> Peter Fopma wrote:
>
> > I would like to find a method to automatically install ASE for NT
and
> > automatically create a DB server from within an installation
procedure.
> >
> > I found posting with reference to the setup program and
parameter -r.
> > But this
> > only seems to solve half the problem since the creation of the
actual DB
> > server
> > is not carried out (at least not for me - or is this maybe an
error due
> > to my messed
> > up installation?)
> > The sybase installation program seems to call syconfig - and to me
it
> > seems
> > as if this program can be called with command line parameters
(start
> > with
> > -i and the program immediately asks for the name of the server you
wish
> > to
> > create...)
> > Does anybody know parameters for syconfig? Or has anybody tried to
> > create an installation using setup with the -r option?
> > Or, if there is a much easier way to do this, which I might have
missed
> > scanning
> > through the postings, please let me know.
> >
> > Thanks,
> > Peter Fopma
>


Andy Price Posted on 2000-06-21 12:39:59.0Z
From: "Andy Price" <andy.price@canada.com>
References: <394E36F0.78D6FB91@labcontrol.com> <394F763A.35BBDD8E@nvestservices.com> <6l9AIMu2$GA.285@forums.sybase.com> <e6i2Way2$GA.285@forums.sybase.com>
Subject: Re: Install / Create ASE automatically
Date: Wed, 21 Jun 2000 13:39:59 +0100
Lines: 143
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <1WE3F832$GA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: dyn50-ras40.screaming.net 212.188.135.50
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1987
Article PK: 1089437

Yes, it can be scripted in NT / 2000. In the %SYBASE%\ase-12\bin directory
is sybatch.exe, but take a look at the %SYBASE%\ase-12_0\sample\server
directory for an example resource file for sybatch called
sybatch_sample.res.

Andy

"Jerry Dennany" <jerdenn@mindspring.com> wrote in message
news:e6i2Way2$GA.285@forums.sybase.com...
>
>
> Actually, Rob, Peter was correct, the Sybase install can be scripted on
NT.
>
> Take a look at the documentation for SYBATCH.exe .
>
>
>
> Jerry Dennany
> Installation Engineer
> jerdenn@mindspring.com
>
>
>
> Rob Verschoor wrote in message <6l9AIMu2$GA.285@forums.sybase.com>...
> Unfortunately, you cannot use resource files on NT as you can on Unix.
> On NT, your only option is to create a batch script (or better a shell
> script using for example the CygWin shell emulator) which runs
> bldmstr.exe to create the server, then creates sybsystemprocs using
> isql and somehow adds the proper entires to the SQL.INI file.
> It sounds more difficult than it is, depending on how advanced you
> want your script to be.
>
> HTH,
>
> Rob
> ----------------------------------------------------------------------
> Rob Verschoor
>
> Certified Sybase Associate DBA for ASE 12.0
> Certified Sybase Professional DBA/SQL Developer for ASE 11.5
> Certified DBA/Performance & Tuning Specialist for Sybase System 11
>
> email mailto:rob@sypron.nl
> WWW http://www.euronet.nl/~syp_rob
> snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
> ----------------------------------------------------------------------
>
> "Peter Veilleux" <pveilleux@nvestservices.com> wrote in message
> news:394F763A.35BBDD8E@nvestservices.com...
> > Peter,
> >
> > I've used resource files before and found it quite easy. Use one of
> the
> > sample resource files in $SYBASE/init/sample_resource_files. Don't
> know if
> > that's the same path on NT. Save the sample as whatever you are
> calling
> > your ASE and make the changes in there. Everything is pretty
> > straight-forward. Here is what the file looks like for 11.5.1 on
> UNIX:
> >
> > nefprod2:sybase:$more srvbuild.adaptive_server.rs
> > sybinit.release_directory: USE_DEFAULT
> > sybinit.product: sqlsrv
> > sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE
> > sqlsrv.new_config: yes
> > sqlsrv.do_add_server: yes
> > sqlsrv.network_protocol_list: tcp
> > sqlsrv.network_hostname_list: PUT_YOUR_HOSTNAME_HERE
> > sqlsrv.network_port_list: PUT_YOUR_PORT_NUMBER_HERE
> > sqlsrv.master_device_physical_name:
> PUT_THE_PATH_OF_YOUR_MASTER_DEVICE_HERE
> > sqlsrv.master_device_size: USE_DEFAULT
> > sqlsrv.master_database_size: USE_DEFAULT
> > sqlsrv.errorlog: USE_DEFAULT
> > sqlsrv.do_upgrade: no
> > sqlsrv.sybsystemprocs_device_physical_name:
> > PUT_THE_PATH_OF_YOUR_SYBSYSTEMPROCS_DEVICE_HERE
> > sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
> > sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
> > sqlsrv.sybsystemdb_device_physical_name:
> > PUT_THE_PATH_OF_YOUR_SYBSYSTEMDB_DEVICE_HERE_OR_REMOVE_THIS_LINE
> > sqlsrv.sybsystemdb_device_size: USE_DEFAULT
> > sqlsrv.sybsystemdb_database_size: USE_DEFAULT
> > sqlsrv.default_backup_server: PUT_YOUR_BACKUP_SERVER_NAME_HERE
> > nefprod2:sybase:$
> >
> > I would recommend filling in as much as possible, even if it is the
> default
> > value. Unfortunately, I don't know much about syconfig without
> taking the
> > time to look at it.
> >
> > Hope this helps....
> >
> > Peter
> >
> >
> > Peter Fopma wrote:
> >
> > > I would like to find a method to automatically install ASE for NT
> and
> > > automatically create a DB server from within an installation
> procedure.
> > >
> > > I found posting with reference to the setup program and
> parameter -r.
> > > But this
> > > only seems to solve half the problem since the creation of the
> actual DB
> > > server
> > > is not carried out (at least not for me - or is this maybe an
> error due
> > > to my messed
> > > up installation?)
> > > The sybase installation program seems to call syconfig - and to me
> it
> > > seems
> > > as if this program can be called with command line parameters
> (start
> > > with
> > > -i and the program immediately asks for the name of the server you
> wish
> > > to
> > > create...)
> > > Does anybody know parameters for syconfig? Or has anybody tried to
> > > create an installation using setup with the -r option?
> > > Or, if there is a much easier way to do this, which I might have
> missed
> > > scanning
> > > through the postings, please let me know.
> > >
> > > Thanks,
> > > Peter Fopma
> >
>
>
>
>


Peter Fopma Posted on 2000-06-21 08:21:58.0Z
Message-ID: <39507B26.E60D34CA@labcontrol.com>
Date: Wed, 21 Jun 2000 10:21:58 +0200
From: Peter Fopma <pf@labcontrol.com>
X-Mailer: Mozilla 4.7 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Jerry Dennany <jerdenn@mindspring.com>
Subject: Re: Install / Create ASE automatically
References: <394E36F0.78D6FB91@labcontrol.com> <394F763A.35BBDD8E@nvestservices.com> <6l9AIMu2$GA.285@forums.sybase.com> <e6i2Way2$GA.285@forums.sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.nt
Lines: 9
NNTP-Posting-Host: pc027.labcontrol.com 195.82.85.155
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1990
Article PK: 1089441

Thanks for your help, I actually stumbled across sybatch as well. But I
could not find any documentation about the program neither in the online
documentation installed with ASE nor on www.sybase.support.com.

Could you please tell me where I can find documentation (or maybe even
post me a documentation file...)?

Thanks,
Peter Fopma


Rob Verschoor Posted on 2000-06-23 12:47:17.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <394E36F0.78D6FB91@labcontrol.com> <394F763A.35BBDD8E@nvestservices.com> <6l9AIMu2$GA.285@forums.sybase.com> <e6i2Way2$GA.285@forums.sybase.com> <39507B26.E60D34CA@labcontrol.com>
Subject: Re: Install / Create ASE automatically
Date: Fri, 23 Jun 2000 14:47:17 +0200
Lines: 37
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <3zGNKKR3$GA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i013.spy.euronet.nl 194.134.26.177
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1975
Article PK: 1089411

OK, I did some research on sybatch: it exists since 11.5.1 (not in
11.5), and it's documented only in the 11.5.1 and 12.0 documentation
on the web (not on the 12.0 Sybooks CD).
I've added details about this on
http://www.euronet.nl/~syp_rob/si4evr.html#nt

Rob
----------------------------------------------------------------------
Rob Verschoor

Certified Sybase Associate DBA for ASE 12.0
Certified Sybase Professional DBA/SQL Developer for ASE 11.5
Certified DBA/Performance & Tuning Specialist for Sybase System 11

email mailto:rob@sypron.nl
WWW http://www.euronet.nl/~syp_rob
snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
----------------------------------------------------------------------

"Peter Fopma" <pf@labcontrol.com> wrote in message
news:39507B26.E60D34CA@labcontrol.com...
> Thanks for your help, I actually stumbled across sybatch as well.
But I
> could not find any documentation about the program neither in the
online
> documentation installed with ASE nor on www.sybase.support.com.
>
> Could you please tell me where I can find documentation (or maybe
even
> post me a documentation file...)?
>
> Thanks,
> Peter Fopma
>


Rob Verschoor Posted on 2000-06-21 05:35:41.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <394E36F0.78D6FB91@labcontrol.com> <394F763A.35BBDD8E@nvestservices.com> <6l9AIMu2$GA.285@forums.sybase.com> <e6i2Way2$GA.285@forums.sybase.com>
Subject: Re: Install / Create ASE automatically
Date: Wed, 21 Jun 2000 07:35:41 +0200
Lines: 150
Organization: Sypron B.V.
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <hM$XXP02$GA.86@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i025.spy.euronet.nl 194.134.26.189
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1991
Article PK: 1089442

Really ? That's new for me... I'll check it out. Since which ASE
version does SYBATCH exist ?

"Jerry Dennany" <jerdenn@mindspring.com> wrote in message
news:e6i2Way2$GA.285@forums.sybase.com...
>
>
> Actually, Rob, Peter was correct, the Sybase install can be scripted
on NT.
>
> Take a look at the documentation for SYBATCH.exe .
>
>
>
> Jerry Dennany
> Installation Engineer
> jerdenn@mindspring.com
>
>
>
> Rob Verschoor wrote in message
<6l9AIMu2$GA.285@forums.sybase.com>...
> Unfortunately, you cannot use resource files on NT as you can on
Unix.
> On NT, your only option is to create a batch script (or better a
shell
> script using for example the CygWin shell emulator) which runs
> bldmstr.exe to create the server, then creates sybsystemprocs using
> isql and somehow adds the proper entires to the SQL.INI file.
> It sounds more difficult than it is, depending on how advanced you
> want your script to be.
>
> HTH,
>
> Rob
> --------------------------------------------------------------------
--
> Rob Verschoor
>
> Certified Sybase Associate DBA for ASE 12.0
> Certified Sybase Professional DBA/SQL Developer for ASE 11.5
> Certified DBA/Performance & Tuning Specialist for Sybase System 11
>
> email mailto:rob@sypron.nl
> WWW http://www.euronet.nl/~syp_rob
> snail Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
> --------------------------------------------------------------------
--
>
> "Peter Veilleux" <pveilleux@nvestservices.com> wrote in message
> news:394F763A.35BBDD8E@nvestservices.com...
> > Peter,
> >
> > I've used resource files before and found it quite easy. Use one
of
> the
> > sample resource files in $SYBASE/init/sample_resource_files.
Don't
> know if
> > that's the same path on NT. Save the sample as whatever you are
> calling
> > your ASE and make the changes in there. Everything is pretty
> > straight-forward. Here is what the file looks like for 11.5.1 on
> UNIX:
> >
> > nefprod2:sybase:$more srvbuild.adaptive_server.rs
> > sybinit.release_directory: USE_DEFAULT
> > sybinit.product: sqlsrv
> > sqlsrv.server_name: PUT_YOUR_SERVER_NAME_HERE
> > sqlsrv.new_config: yes
> > sqlsrv.do_add_server: yes
> > sqlsrv.network_protocol_list: tcp
> > sqlsrv.network_hostname_list: PUT_YOUR_HOSTNAME_HERE
> > sqlsrv.network_port_list: PUT_YOUR_PORT_NUMBER_HERE
> > sqlsrv.master_device_physical_name:
> PUT_THE_PATH_OF_YOUR_MASTER_DEVICE_HERE
> > sqlsrv.master_device_size: USE_DEFAULT
> > sqlsrv.master_database_size: USE_DEFAULT
> > sqlsrv.errorlog: USE_DEFAULT
> > sqlsrv.do_upgrade: no
> > sqlsrv.sybsystemprocs_device_physical_name:
> > PUT_THE_PATH_OF_YOUR_SYBSYSTEMPROCS_DEVICE_HERE
> > sqlsrv.sybsystemprocs_device_size: USE_DEFAULT
> > sqlsrv.sybsystemprocs_database_size: USE_DEFAULT
> > sqlsrv.sybsystemdb_device_physical_name:
> > PUT_THE_PATH_OF_YOUR_SYBSYSTEMDB_DEVICE_HERE_OR_REMOVE_THIS_LINE
> > sqlsrv.sybsystemdb_device_size: USE_DEFAULT
> > sqlsrv.sybsystemdb_database_size: USE_DEFAULT
> > sqlsrv.default_backup_server: PUT_YOUR_BACKUP_SERVER_NAME_HERE
> > nefprod2:sybase:$
> >
> > I would recommend filling in as much as possible, even if it is
the
> default
> > value. Unfortunately, I don't know much about syconfig without
> taking the
> > time to look at it.
> >
> > Hope this helps....
> >
> > Peter
> >
> >
> > Peter Fopma wrote:
> >
> > > I would like to find a method to automatically install ASE for
NT
> and
> > > automatically create a DB server from within an installation
> procedure.
> > >
> > > I found posting with reference to the setup program and
> parameter -r.
> > > But this
> > > only seems to solve half the problem since the creation of the
> actual DB
> > > server
> > > is not carried out (at least not for me - or is this maybe an
> error due
> > > to my messed
> > > up installation?)
> > > The sybase installation program seems to call syconfig - and to
me
> it
> > > seems
> > > as if this program can be called with command line parameters
> (start
> > > with
> > > -i and the program immediately asks for the name of the server
you
> wish
> > > to
> > > create...)
> > > Does anybody know parameters for syconfig? Or has anybody tried
to
> > > create an installation using setup with the -r option?
> > > Or, if there is a much easier way to do this, which I might have
> missed
> > > scanning
> > > through the postings, please let me know.
> > >
> > > Thanks,
> > > Peter Fopma
> >
>
>
>
>


Jerry Dennany Posted on 2000-06-22 13:41:18.0Z
From: "Jerry Dennany" <jerdenn@mindspring.com>
References: <394E36F0.78D6FB91@labcontrol.com> <394F763A.35BBDD8E@nvestservices.com> <6l9AIMu2$GA.285@forums.sybase.com> <e6i2Way2$GA.285@forums.sybase.com> <hM$XXP02$GA.86@forums.sybase.com>
Subject: Re: Install / Create ASE automatically
Date: Thu, 22 Jun 2000 09:41:18 -0400
Lines: 24
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <vq1MXDF3$GA.86@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: corp.priceline.com 208.219.50.155
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1977
Article PK: 1089413

I used it in 11.5.1, though if I remember correctly, there was a bug where
you would have to add the registry key


[HKEY_LOCAL_MACHINE\SOFTWARE\SYBASE\SERVER\servername]
"Version"="11.5.1.0"


before it would work properly.


Jerry Dennany
jerdenn@mindspring.com

Rob Verschoor <rob@sypron.nl> wrote in message
news:hM$XXP02$GA.86@forums.sybase.com...
> Really ? That's new for me... I'll check it out. Since which ASE
> version does SYBATCH exist ?