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.

solaris doubt

6 posts in Backup and Recovery Last posting was on 2001-03-01 00:34:38.0Z
Sam Posted on 2001-02-27 20:22:54.0Z
From: sam
Date: Tue, 27 Feb 2001 15:22:54 -0500
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: solaris doubt
Message-ID: <44DF0F82BFFFE205006FF5DA85256A00.006FF5EB85256A00@webforums>
Lines: 13
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:465
Article PK: 1061314

Hi,
we are running sybase 11.9.2 under soalris 2.6.I have a question
in the auto start and shutdown scripts.start script works fine for me.
but i am not sure whether my shutdown script is working fine.
1.They say the shutdown script should start with K... and associate
with etc/rc2.d or which one should we associate and when we
do a reboot, in the sybase log should it have a shutdown by request.
I am not seeing that entry in the log.


Any kind of help is appreciated.

sam


Anthony Mandic <amandic Posted on 2001-02-28 11:00:12.0Z
Date: Wed, 28 Feb 2001 22:00:12 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: solaris doubt
References: <44DF0F82BFFFE205006FF5DA85256A00.006FF5EB85256A00@webforums>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <AHYQKjXoAHA.253@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 26
NNTP-Posting-Host: CPE-208-111-111-203.syd.dav.net.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:463
Article PK: 1060976


sam wrote:

> we are running sybase 11.9.2 under soalris 2.6.I have a question
> in the auto start and shutdown scripts.start script works fine for me.
> but i am not sure whether my shutdown script is working fine.
> 1.They say the shutdown script should start with K... and associate
> with etc/rc2.d or which one should we associate and when we
> do a reboot, in the sybase log should it have a shutdown by request.
> I am not seeing that entry in the log.

You need a link to the script in each of the possible shutdown
run states. I have -

-rwxr----- 6 sybase sybase 710 Sep 19 19:47 rc0.d/K25sybase
-rwxr----- 6 sybase sybase 710 Sep 19 19:47 rc1.d/K25sybase
-rwxr----- 6 sybase sybase 710 Sep 19 19:47 rc2.d/K25sybase
-rwxr----- 6 sybase sybase 710 Sep 19 19:47 rcS.d/K25sybase

Which are all hard linked to /etc/init.d/sybase. I also have
a sample script at http://www.mbay.net/~mpeppler/sos/sos.html

-am © 2001


George Saylor Posted on 2001-02-28 12:09:25.0Z
From: "George Saylor" <GMSAYLORIII@email.msn.com>
References: <44DF0F82BFFFE205006FF5DA85256A00.006FF5EB85256A00@webforums> <AHYQKjXoAHA.253@forums.sybase.com>
Subject: Re: solaris doubt
Date: Wed, 28 Feb 2001 07:09:25 -0500
Lines: 43
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: <hPquFIYoAHA.198@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 1Cust105.tnt1.baltimore.md.da.uu.net 63.24.126.105
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:462
Article PK: 1060970

One thing I noticed on the SOS is that you recommend placing the start
script in rc3.d, my UNIX Admin keeps ours in rc2.d (on AIX) and says that
this is "the default" run state there. It seems that Solaris(7 at least)
goes to init 3 to start network files system daemons, but all other files
systems and network services are started/mounted in rc2.

So my question is *why* do you choose rc3 to start Sybase on Solaris, would
you think it is applicable on AIX? One idea we threw around was using rc3.d
instead of /etc/inittab at run level 2 so that running init 2 would bring
down only Sybase, but based on what I read in the Solaris Admin guide, it
would seem the idea won't port because of the NFS services...

George

Anthony Mandic <amandic@*t.com.au> wrote in message
news:AHYQKjXoAHA.253@forums.sybase.com...
> sam wrote:
>
> > we are running sybase 11.9.2 under soalris 2.6.I have a question
> > in the auto start and shutdown scripts.start script works fine for me.
> > but i am not sure whether my shutdown script is working fine.
> > 1.They say the shutdown script should start with K... and
associate
> > with etc/rc2.d or which one should we associate and when we
> > do a reboot, in the sybase log should it have a shutdown by request.
> > I am not seeing that entry in the log.
>
> You need a link to the script in each of the possible shutdown
> run states. I have -
>
> -rwxr----- 6 sybase sybase 710 Sep 19 19:47 rc0.d/K25sybase
> -rwxr----- 6 sybase sybase 710 Sep 19 19:47 rc1.d/K25sybase
> -rwxr----- 6 sybase sybase 710 Sep 19 19:47 rc2.d/K25sybase
> -rwxr----- 6 sybase sybase 710 Sep 19 19:47 rcS.d/K25sybase
>
> Which are all hard linked to /etc/init.d/sybase. I also have
> a sample script at http://www.mbay.net/~mpeppler/sos/sos.html
>
> -am © 2001


Anthony Mandic <amandic Posted on 2001-02-28 13:09:47.0Z
Date: Thu, 01 Mar 2001 00:09:47 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.61 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: solaris doubt
References: <44DF0F82BFFFE205006FF5DA85256A00.006FF5EB85256A00@webforums> <AHYQKjXoAHA.253@forums.sybase.com> <hPquFIYoAHA.198@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <yOZvkrYoAHA.198@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 31
NNTP-Posting-Host: CPE-208-111-111-203.syd.dav.net.au 203.111.111.208
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:461
Article PK: 1060968


George Saylor wrote:
>
> One thing I noticed on the SOS is that you recommend placing the start
> script in rc3.d, my UNIX Admin keeps ours in rc2.d (on AIX) and says that
> this is "the default" run state there. It seems that Solaris(7 at least)
> goes to init 3 to start network files system daemons, but all other files
> systems and network services are started/mounted in rc2.

Read the init man page. Run state 3 is described as extending
local resources to the network.

> So my question is *why* do you choose rc3 to start Sybase on Solaris, would
> you think it is applicable on AIX? One idea we threw around was using rc3.d
> instead of /etc/inittab at run level 2 so that running init 2 would bring
> down only Sybase, but based on what I read in the Solaris Admin guide, it
> would seem the idea won't port because of the NFS services...

I can't say what differences there are between AIX and SunOS on
this issue. Note that scripts have different designations when
they are stopped (starting with K rather than S). If you look
thru the rc directories, you'll note some uniformity with some
of the scripts with respect to which directories their stop
scripts are in.

-am © 2001


George Saylor Posted on 2001-02-28 23:47:52.0Z
From: "George Saylor" <GMSAYLORIII@email.msn.com>
References: <44DF0F82BFFFE205006FF5DA85256A00.006FF5EB85256A00@webforums> <AHYQKjXoAHA.253@forums.sybase.com> <hPquFIYoAHA.198@forums.sybase.com> <yOZvkrYoAHA.198@forums.sybase.com>
Subject: Re: solaris doubt
Date: Wed, 28 Feb 2001 18:47:52 -0500
Lines: 48
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: <EJQkqOeoAHA.277@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
NNTP-Posting-Host: 1Cust188.tnt1.baltimore.md.da.uu.net 63.24.126.188
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:459
Article PK: 1060964


Anthony Mandic <amandic@*t.com.au> wrote in message
news:yOZvkrYoAHA.198@forums.sybase.com...
> George Saylor wrote:
> >
> > One thing I noticed on the SOS is that you recommend placing the start
> > script in rc3.d, my UNIX Admin keeps ours in rc2.d (on AIX) and says
that
> > this is "the default" run state there. It seems that Solaris(7 at
least)
> > goes to init 3 to start network files system daemons, but all other
files
> > systems and network services are started/mounted in rc2.
>
> Read the init man page. Run state 3 is described as extending
> local resources to the network.

Yup, this pretty much means that I will need two different scripts for
shutdown, ie I wouldn't want to shut off NFS on our Suns just because we are
applying an EBF etc...

>
> > So my question is *why* do you choose rc3 to start Sybase on Solaris,
would
> > you think it is applicable on AIX? One idea we threw around was using
rc3.d
> > instead of /etc/inittab at run level 2 so that running init 2 would
bring
> > down only Sybase, but based on what I read in the Solaris Admin guide,
it
> > would seem the idea won't port because of the NFS services...
>
> I can't say what differences there are between AIX and SunOS on

who -r on the Sun's shows 3 and AIX shows 2. These are defults
respectively. AIX 4.3.3 does now support the K and S scripts for rc_.d, so
at least the names can be the same. We used to use /etc/inittab and just
specify to wait or not wait for completion of certain commands.

> this issue. Note that scripts have different designations when
> they are stopped (starting with K rather than S). If you look
> thru the rc directories, you'll note some uniformity with some
> of the scripts with respect to which directories their stop
> scripts are in.
>
> -am © 2001


Anthony Mandic <amandic Posted on 2001-03-01 00:34:38.0Z
Date: Thu, 01 Mar 2001 11:34:38 +1100
From: Anthony Mandic <amandic@*t.com.au>
Organization: Mandic Consulting Pty. Ltd.
X-Mailer: Mozilla 4.72 [en] (X11; U; Linux 2.2.14-5.0 i686)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: solaris doubt
References: <44DF0F82BFFFE205006FF5DA85256A00.006FF5EB85256A00@webforums> <AHYQKjXoAHA.253@forums.sybase.com> <hPquFIYoAHA.198@forums.sybase.com> <yOZvkrYoAHA.198@forums.sybase.com> <EJQkqOeoAHA.277@forums.sybase.com>
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
Message-ID: <FbjPimeoAHA.253@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 36
NNTP-Posting-Host: 210.9.51.46
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:458
Article PK: 1060967


George Saylor wrote:

> Yup, this pretty much means that I will need two different scripts for
> shutdown, ie I wouldn't want to shut off NFS on our Suns just because we are
> applying an EBF etc...

I'm not sure what you mean here. The traditional method is to install
your start/stop script in /etc/init.d and hard link to the relevant
rc?.d directories. If you just want to shutdown ASE without affecting
anything else (or to change the run state), you can just invoke the
script by itself. I.e. -

# /etc/init.d/sybase stop

Of course, you can always connect thru an SQL session and manually
do a shutdown in these sorts of circumstances (which is always a
good idea. You need to check that users are off etc.).

> > I can't say what differences there are between AIX and SunOS on
>
> who -r on the Sun's shows 3 and AIX shows 2. These are defults
> respectively.

Well, they're aren't so much defaults as the normal interactive
run state. So AIX is different. Interesting.

> AIX 4.3.3 does now support the K and S scripts for rc_.d, so
> at least the names can be the same. We used to use /etc/inittab and just
> specify to wait or not wait for completion of certain commands.

I would read thru the AIX docs and man pages for their definitions
of the run states. You could also compare with the other scripts
that are in the rc?.d directories.

-am © 2001