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.

xp_cmdshell

3 posts in General Discussion Last posting was on 2012-06-21 23:39:54.0Z
Raj Posted on 2012-06-21 00:16:47.0Z
Sender: 7f36.4fe265ec.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: xp_cmdshell
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fe267ec.7f7f.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 20 Jun 2012 17:16:47 -0700
X-Trace: forums-1-dub 1340237807 172.20.134.41 (20 Jun 2012 17:16:47 -0700)
X-Original-Trace: 20 Jun 2012 17:16:47 -0700, 172.20.134.41
Lines: 16
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31203
Article PK: 74091

Hi,

We have database&application on the same AIX box. We are
in process of splitting them on to 2 different servers. At
the moment, Application team runs few OS scripts using
xp_cmdshell. After we done this separation, Is there any way
they can still run OS scripts in application server via
'xp_cmdshell' ? I know they can log into the database server
from application, But 'xp_cmdshell' will still show the OS
files/information of database server, NOT the application
server.
Hope it makes sense. Let me know if you need more detail.


Thanks,
Raj


Rob V Posted on 2012-06-21 04:45:11.0Z
From: Rob V <rob@sypron.nl>
Reply-To: rob@sypron.nl
User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:12.0) Gecko/20120428 Thunderbird/12.0.1
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: xp_cmdshell
References: <4fe267ec.7f7f.1681692777@sybase.com>
In-Reply-To: <4fe267ec.7f7f.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4fe2a6d7$1@forums-1-dub>
Date: 20 Jun 2012 21:45:11 -0700
X-Trace: forums-1-dub 1340253911 10.22.241.152 (20 Jun 2012 21:45:11 -0700)
X-Original-Trace: 20 Jun 2012 21:45:11 -0700, vip152.sybase.com
Lines: 42
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31204
Article PK: 74093


On 21-Jun-2012 02:16, Raj wrote:
> Hi,
>
> We have database&application on the same AIX box. We are
> in process of splitting them on to 2 different servers. At
> the moment, Application team runs few OS scripts using
> xp_cmdshell. After we done this separation, Is there any way
> they can still run OS scripts in application server via
> 'xp_cmdshell' ? I know they can log into the database server
> from application, But 'xp_cmdshell' will still show the OS
> files/information of database server, NOT the application
> server.
> Hope it makes sense. Let me know if you need more detail.
>
>
> Thanks,
> Raj

If you can execute a script from the ASE host, then you can execute it
with xp_cmdhsell. So the question is: how can you execute a script on
another host? There are various solutions for this, for example 'rsh'.
So pick an O/S-level solution for this issue and then run it from
xp_cmdshell.

--
HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Professional DBA for Sybase ASE, IQ, Replication Server

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE"
"The Complete Sybase IQ Quick Reference Guide" (new!)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter: @rob_verschoor
Sypron B.V., The Netherlands | Chamber of Commerce 27138666
-----------------------------------------------------------------


Raj Posted on 2012-06-21 23:39:54.0Z
Sender: 31a5.4fe3b07c.1804289383@sybase.com
From: Raj
Newsgroups: sybase.public.ase.general
Subject: Re: xp_cmdshell
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4fe3b0ca.31ba.1681692777@sybase.com>
References: <4fe2a6d7$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 21 Jun 2012 16:39:54 -0700
X-Trace: forums-1-dub 1340321994 172.20.134.41 (21 Jun 2012 16:39:54 -0700)
X-Original-Trace: 21 Jun 2012 16:39:54 -0700, 172.20.134.41
Lines: 50
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:31205
Article PK: 74094

Thanks Rob.

> On 21-Jun-2012 02:16, Raj wrote:
> > Hi,
> >
> > We have database&application on the same AIX box. We
> > are in process of splitting them on to 2 different
> > servers. At the moment, Application team runs few OS
> > scripts using xp_cmdshell. After we done this separation
> > , Is there any way they can still run OS scripts in
> > application server via 'xp_cmdshell' ? I know they can
> > log into the database server from application, But
> > 'xp_cmdshell' will still show the OS files/information
> > of database server, NOT the application server.
> > Hope it makes sense. Let me know if you need more
> detail. >
> >
> > Thanks,
> > Raj
>
> If you can execute a script from the ASE host, then you
> can execute it with xp_cmdhsell. So the question is: how
> can you execute a script on another host? There are
> various solutions for this, for example 'rsh'. So pick an
> O/S-level solution for this issue and then run it from
> xp_cmdshell.
>
> --
> HTH,
>
> Rob V.
> ----------------------------------------------------------
> ------- Rob Verschoor
>
> Certified Professional DBA for Sybase ASE, IQ, Replication
> Server
>
> Author of Sybase books (order online at
> www.sypron.nl/shop): "Tips, Tricks & Recipes for Sybase
> ASE" "The Complete Sybase IQ Quick Reference Guide" (new!)
> "The Complete Sybase ASE Quick Reference Guide"
> "The Complete Sybase Replication Server Quick Reference
> Guide"
>
> rob@NO.SPAM.sypron.nl | www.sypron.nl | Twitter:
> @rob_verschoor Sypron B.V., The Netherlands | Chamber of
> Commerce 27138666
> ----------------------------------------------------------
> -------