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.

Problem with contig.exe and CALL xp_cmdshell

9 posts in General Discussion Last posting was on 2009-03-30 12:30:15.0Z
ingmar.beck Posted on 2009-03-20 16:35:34.0Z
Sender: 7259.49c3c1fa.1804289383@sybase.com
From: ingmar.beck@eccos-pro.com
Newsgroups: ianywhere.public.general
Subject: Problem with contig.exe and CALL xp_cmdshell
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49c3c5d6.732d.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 20 Mar 2009 08:35:34 -0800
X-Trace: forums-1-dub 1237566934 10.22.241.41 (20 Mar 2009 08:35:34 -0800)
X-Original-Trace: 20 Mar 2009 08:35:34 -0800, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7422
Article PK: 5840

Hi!
When I wanted to implement the tip "How do I ensure the
temporary dbspace remains contiguous?" of B. Carter, there
was a problem. The process "contig.exe" suspended. If
contig.exe is started, the output file is created.
Otherwise, nothing happens.
Tested with ASA 9.0.2 and 11.0.1.
I used "contig.exe" in the current version (1.55).
Other commands are running with "CALL xp_cmdshell" without
problems. Even another defragmentation tool (JkDefrag)
works.
Where could the problem be?


Breck Carter [TeamSybase] Posted on 2009-03-21 07:56:50.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Problem with contig.exe and CALL xp_cmdshell
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com>
References: <49c3c5d6.732d.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 20 Mar 2009 23:56:50 -0800
X-Trace: forums-1-dub 1237622210 10.22.241.152 (20 Mar 2009 23:56:50 -0800)
X-Original-Trace: 20 Mar 2009 23:56:50 -0800, vip152.sybase.com
Lines: 34
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7425
Article PK: 5837

Is the SQL Anywhere engine running as a service, or is an ordinary
"desktop" application? If it is a service, can you try it as a desktop
app (JUST to narrow down the cause).

What Operating System are you using? e.g., XP, RedHat, etc.

Assuming Windows: What does Task Manager say? Does anything show up in
the Windows error logs?

FYI I wrote an article about it here
http://sqlanywhere.blogspot.com/2008/02/defragmenting-temporary-file.html

Breck

On 20 Mar 2009 08:35:34 -0800, ingmar.beck@eccos-pro.com wrote:

>Hi!
>When I wanted to implement the tip "How do I ensure the
>temporary dbspace remains contiguous?" of B. Carter, there
>was a problem. The process "contig.exe" suspended. If
>contig.exe is started, the output file is created.
>Otherwise, nothing happens.
>Tested with ASA 9.0.2 and 11.0.1.
>I used "contig.exe" in the current version (1.55).
>Other commands are running with "CALL xp_cmdshell" without
>problems. Even another defragmentation tool (JkDefrag)
>works.
>Where could the problem be?

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


<Ingmar> Posted on 2009-03-24 14:23:19.0Z
From: <Ingmar>
Newsgroups: ianywhere.public.general
References: <49c3c5d6.732d.1681692777@sybase.com> <8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com>
Subject: Re: Problem with contig.exe and CALL xp_cmdshell
Lines: 54
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49c8ecd7@forums-1-dub>
Date: 24 Mar 2009 06:23:19 -0800
X-Trace: forums-1-dub 1237904599 10.22.241.152 (24 Mar 2009 06:23:19 -0800)
X-Original-Trace: 24 Mar 2009 06:23:19 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7428
Article PK: 5842

Hello Breck!

I don't know why, but after a few tests with various settings, it is running
now ... in the original version.

But I have another question ... is it possible / allowed to defragment (with
contig.exe) a running database-file (engine) or the log-file of a running
database?
Sense is to check in a certain time interval whether the level of free pages
below a certain limit is. If this occurs, the DB-space will enlarged and
then (in started mode) defragmented.

Ingmar


"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
Newsbeitrag news:8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com...

> Is the SQL Anywhere engine running as a service, or is an ordinary
> "desktop" application? If it is a service, can you try it as a desktop
> app (JUST to narrow down the cause).
>
> What Operating System are you using? e.g., XP, RedHat, etc.
>
> Assuming Windows: What does Task Manager say? Does anything show up in
> the Windows error logs?
>
> FYI I wrote an article about it here
> http://sqlanywhere.blogspot.com/2008/02/defragmenting-temporary-file.html
>
> Breck
>
> On 20 Mar 2009 08:35:34 -0800, ingmar.beck@eccos-pro.com wrote:
>
>>Hi!
>>When I wanted to implement the tip "How do I ensure the
>>temporary dbspace remains contiguous?" of B. Carter, there
>>was a problem. The process "contig.exe" suspended. If
>>contig.exe is started, the output file is created.
>>Otherwise, nothing happens.
>>Tested with ASA 9.0.2 and 11.0.1.
>>I used "contig.exe" in the current version (1.55).
>>Other commands are running with "CALL xp_cmdshell" without
>>problems. Even another defragmentation tool (JkDefrag)
>>works.
>>Where could the problem be?
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com
>


Breck Carter [TeamSybase] Posted on 2009-03-24 20:15:06.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Problem with contig.exe and CALL xp_cmdshell
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <39fis4988sr8o331bfvu291t52ek6c968d@4ax.com>
References: <49c3c5d6.732d.1681692777@sybase.com> <8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com> <49c8ecd7@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 24 Mar 2009 12:15:06 -0800
X-Trace: forums-1-dub 1237925706 10.22.241.152 (24 Mar 2009 12:15:06 -0800)
X-Original-Trace: 24 Mar 2009 12:15:06 -0800, vip152.sybase.com
Lines: 81
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7431
Article PK: 5845

I have had no problems running contig.exe or Diskeeper on active
databases. I believe it is important to keep those programs up to date
with respect to operating systems. In other words, I would be
uncomfortable running old versions of either on a brand-new version of
Windows. FWIW I am a HUGE fan of Diskeeper... and I have a lot more
experience with it than contig.exe for the simple reason that it has a
much higher level of automation (i.e., I leave it running 24 x 365).

With Diskeeper, you could simply grow the file, then let Diskeeper
defrag when it gets around to it (screensaver mode is nice).

Defragmenting the db is very important, the temp file important (but
arguably less important than the db), and the log file not so
important. The log file is written sequentially, and AFAIK only
dbremote.exe and dbmlsync.exe read it (in the normal case, when you
aren't recovering from disaster :)

Breck

On 24 Mar 2009 06:23:19 -0800, <Ingmar> wrote:

>Hello Breck!
>
>I don't know why, but after a few tests with various settings, it is running
>now ... in the original version.
>
>But I have another question ... is it possible / allowed to defragment (with
>contig.exe) a running database-file (engine) or the log-file of a running
>database?
>Sense is to check in a certain time interval whether the level of free pages
>below a certain limit is. If this occurs, the DB-space will enlarged and
>then (in started mode) defragmented.
>
>Ingmar
>
>
>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>Newsbeitrag news:8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com...
>> Is the SQL Anywhere engine running as a service, or is an ordinary
>> "desktop" application? If it is a service, can you try it as a desktop
>> app (JUST to narrow down the cause).
>>
>> What Operating System are you using? e.g., XP, RedHat, etc.
>>
>> Assuming Windows: What does Task Manager say? Does anything show up in
>> the Windows error logs?
>>
>> FYI I wrote an article about it here
>> http://sqlanywhere.blogspot.com/2008/02/defragmenting-temporary-file.html
>>
>> Breck
>>
>> On 20 Mar 2009 08:35:34 -0800, ingmar.beck@eccos-pro.com wrote:
>>
>>>Hi!
>>>When I wanted to implement the tip "How do I ensure the
>>>temporary dbspace remains contiguous?" of B. Carter, there
>>>was a problem. The process "contig.exe" suspended. If
>>>contig.exe is started, the output file is created.
>>>Otherwise, nothing happens.
>>>Tested with ASA 9.0.2 and 11.0.1.
>>>I used "contig.exe" in the current version (1.55).
>>>Other commands are running with "CALL xp_cmdshell" without
>>>problems. Even another defragmentation tool (JkDefrag)
>>>works.
>>>Where could the problem be?
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com
>>
>

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


<Ingmar> Posted on 2009-03-27 17:58:31.0Z
From: <Ingmar>
Newsgroups: ianywhere.public.general
References: <49c3c5d6.732d.1681692777@sybase.com> <8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com> <49c8ecd7@forums-1-dub> <39fis4988sr8o331bfvu291t52ek6c968d@4ax.com>
Subject: Re: Problem with contig.exe and CALL xp_cmdshell
Lines: 98
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49cd13c7@forums-1-dub>
Date: 27 Mar 2009 09:58:31 -0800
X-Trace: forums-1-dub 1238176711 10.22.241.152 (27 Mar 2009 09:58:31 -0800)
X-Original-Trace: 27 Mar 2009 09:58:31 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7446
Article PK: 5862

hello Breck,
thx for your answer.
I tried the procedure on an other PC and have the same problem.
contig hangs... but only when the server ist started as service.
On the first system its ok now... the second system has now the problem and
i don't know where the difference is.
have u an idee why there ist sometimes a problem when the db-server runs as
service with user "system"?

"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
Newsbeitrag news:39fis4988sr8o331bfvu291t52ek6c968d@4ax.com...

>I have had no problems running contig.exe or Diskeeper on active
> databases. I believe it is important to keep those programs up to date
> with respect to operating systems. In other words, I would be
> uncomfortable running old versions of either on a brand-new version of
> Windows. FWIW I am a HUGE fan of Diskeeper... and I have a lot more
> experience with it than contig.exe for the simple reason that it has a
> much higher level of automation (i.e., I leave it running 24 x 365).
>
> With Diskeeper, you could simply grow the file, then let Diskeeper
> defrag when it gets around to it (screensaver mode is nice).
>
> Defragmenting the db is very important, the temp file important (but
> arguably less important than the db), and the log file not so
> important. The log file is written sequentially, and AFAIK only
> dbremote.exe and dbmlsync.exe read it (in the normal case, when you
> aren't recovering from disaster :)
>
> Breck
>
>
> On 24 Mar 2009 06:23:19 -0800, <Ingmar> wrote:
>
>>Hello Breck!
>>
>>I don't know why, but after a few tests with various settings, it is
>>running
>>now ... in the original version.
>>
>>But I have another question ... is it possible / allowed to defragment
>>(with
>>contig.exe) a running database-file (engine) or the log-file of a running
>>database?
>>Sense is to check in a certain time interval whether the level of free
>>pages
>>below a certain limit is. If this occurs, the DB-space will enlarged and
>>then (in started mode) defragmented.
>>
>>Ingmar
>>
>>
>>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>>Newsbeitrag news:8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com...
>>> Is the SQL Anywhere engine running as a service, or is an ordinary
>>> "desktop" application? If it is a service, can you try it as a desktop
>>> app (JUST to narrow down the cause).
>>>
>>> What Operating System are you using? e.g., XP, RedHat, etc.
>>>
>>> Assuming Windows: What does Task Manager say? Does anything show up in
>>> the Windows error logs?
>>>
>>> FYI I wrote an article about it here
>>> http://sqlanywhere.blogspot.com/2008/02/defragmenting-temporary-file.html
>>>
>>> Breck
>>>
>>> On 20 Mar 2009 08:35:34 -0800, ingmar.beck@eccos-pro.com wrote:
>>>
>>>>Hi!
>>>>When I wanted to implement the tip "How do I ensure the
>>>>temporary dbspace remains contiguous?" of B. Carter, there
>>>>was a problem. The process "contig.exe" suspended. If
>>>>contig.exe is started, the output file is created.
>>>>Otherwise, nothing happens.
>>>>Tested with ASA 9.0.2 and 11.0.1.
>>>>I used "contig.exe" in the current version (1.55).
>>>>Other commands are running with "CALL xp_cmdshell" without
>>>>problems. Even another defragmentation tool (JkDefrag)
>>>>works.
>>>>Where could the problem be?
>>>
>>> --
>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> breck.carter@risingroad.com
>>>
>>
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com
>


Breck Carter [TeamSybase] Posted on 2009-03-29 12:32:19.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Problem with contig.exe and CALL xp_cmdshell
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <1spus41767gkavqmasvrp60rl2ms9fsmm2@4ax.com>
References: <49c3c5d6.732d.1681692777@sybase.com> <8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com> <49c8ecd7@forums-1-dub> <39fis4988sr8o331bfvu291t52ek6c968d@4ax.com> <49cd13c7@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 29 Mar 2009 04:32:19 -0800
X-Trace: forums-1-dub 1238329939 10.22.241.152 (29 Mar 2009 04:32:19 -0800)
X-Original-Trace: 29 Mar 2009 04:32:19 -0800, vip152.sybase.com
Lines: 128
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7451
Article PK: 5864

I apologize if you have already answered these questions:

Have you downloaded the most recent version of contig.exe?

Have you tried launching contig.exe via xp_cmdshell from inside the
running engine? I don't know if that will work at all, let alone solve
your problem, but it might change the security attributes of the
environment contig is running in... if that is the problem.

Have you tried asking the author? It's one guy, I'm not sure how to
reach him, but he is universally well-liked. There may be something
that dbsrv*.exe is doing, as a service, that is blocking contig.

http://technet.microsoft.com/en-ca/sysinternals/bb897428.aspx

Breck



Personally, I do not use contig.exe in production environments, nor do
I recommend it, simply because it is delivered "as is"

On 27 Mar 2009 09:58:31 -0800, <Ingmar> wrote:

>hello Breck,
>thx for your answer.
>I tried the procedure on an other PC and have the same problem.
>contig hangs... but only when the server ist started as service.
>On the first system its ok now... the second system has now the problem and
>i don't know where the difference is.
>have u an idee why there ist sometimes a problem when the db-server runs as
>service with user "system"?
>
>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>Newsbeitrag news:39fis4988sr8o331bfvu291t52ek6c968d@4ax.com...
>>I have had no problems running contig.exe or Diskeeper on active
>> databases. I believe it is important to keep those programs up to date
>> with respect to operating systems. In other words, I would be
>> uncomfortable running old versions of either on a brand-new version of
>> Windows. FWIW I am a HUGE fan of Diskeeper... and I have a lot more
>> experience with it than contig.exe for the simple reason that it has a
>> much higher level of automation (i.e., I leave it running 24 x 365).
>>
>> With Diskeeper, you could simply grow the file, then let Diskeeper
>> defrag when it gets around to it (screensaver mode is nice).
>>
>> Defragmenting the db is very important, the temp file important (but
>> arguably less important than the db), and the log file not so
>> important. The log file is written sequentially, and AFAIK only
>> dbremote.exe and dbmlsync.exe read it (in the normal case, when you
>> aren't recovering from disaster :)
>>
>> Breck
>>
>>
>> On 24 Mar 2009 06:23:19 -0800, <Ingmar> wrote:
>>
>>>Hello Breck!
>>>
>>>I don't know why, but after a few tests with various settings, it is
>>>running
>>>now ... in the original version.
>>>
>>>But I have another question ... is it possible / allowed to defragment
>>>(with
>>>contig.exe) a running database-file (engine) or the log-file of a running
>>>database?
>>>Sense is to check in a certain time interval whether the level of free
>>>pages
>>>below a certain limit is. If this occurs, the DB-space will enlarged and
>>>then (in started mode) defragmented.
>>>
>>>Ingmar
>>>
>>>
>>>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>>>Newsbeitrag news:8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com...
>>>> Is the SQL Anywhere engine running as a service, or is an ordinary
>>>> "desktop" application? If it is a service, can you try it as a desktop
>>>> app (JUST to narrow down the cause).
>>>>
>>>> What Operating System are you using? e.g., XP, RedHat, etc.
>>>>
>>>> Assuming Windows: What does Task Manager say? Does anything show up in
>>>> the Windows error logs?
>>>>
>>>> FYI I wrote an article about it here
>>>> http://sqlanywhere.blogspot.com/2008/02/defragmenting-temporary-file.html
>>>>
>>>> Breck
>>>>
>>>> On 20 Mar 2009 08:35:34 -0800, ingmar.beck@eccos-pro.com wrote:
>>>>
>>>>>Hi!
>>>>>When I wanted to implement the tip "How do I ensure the
>>>>>temporary dbspace remains contiguous?" of B. Carter, there
>>>>>was a problem. The process "contig.exe" suspended. If
>>>>>contig.exe is started, the output file is created.
>>>>>Otherwise, nothing happens.
>>>>>Tested with ASA 9.0.2 and 11.0.1.
>>>>>I used "contig.exe" in the current version (1.55).
>>>>>Other commands are running with "CALL xp_cmdshell" without
>>>>>problems. Even another defragmentation tool (JkDefrag)
>>>>>works.
>>>>>Where could the problem be?
>>>>
>>>> --
>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>
>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>> breck.carter@risingroad.com
>>>>
>>>
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com
>>
>

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


<Ingmar> Posted on 2009-03-30 12:02:04.0Z
From: <Ingmar>
Newsgroups: ianywhere.public.general
References: <49c3c5d6.732d.1681692777@sybase.com> <8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com> <49c8ecd7@forums-1-dub> <39fis4988sr8o331bfvu291t52ek6c968d@4ax.com> <49cd13c7@forums-1-dub> <1spus41767gkavqmasvrp60rl2ms9fsmm2@4ax.com>
Subject: Solution: Problem with contig.exe and CALL xp_cmdshell
Lines: 150
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5512
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49d0b4bc@forums-1-dub>
Date: 30 Mar 2009 04:02:04 -0800
X-Trace: forums-1-dub 1238414524 10.22.241.152 (30 Mar 2009 04:02:04 -0800)
X-Original-Trace: 30 Mar 2009 04:02:04 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7454
Article PK: 5865

Hi Breck,

I added a topic in the "Sysinternals Utilities Forum and now I have the
solution.

>> I need an additional switch "/accepteula" to accept the EULA acceptance
>> dialog.

It seems to be a problem / a feature of the current version (1.55).

Thank you for your efforts and your patience ;-)
Ingmar



"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
Newsbeitrag news:1spus41767gkavqmasvrp60rl2ms9fsmm2@4ax.com...
>I apologize if you have already answered these questions:
>
> Have you downloaded the most recent version of contig.exe?
>
> Have you tried launching contig.exe via xp_cmdshell from inside the
> running engine? I don't know if that will work at all, let alone solve
> your problem, but it might change the security attributes of the
> environment contig is running in... if that is the problem.
>
> Have you tried asking the author? It's one guy, I'm not sure how to
> reach him, but he is universally well-liked. There may be something
> that dbsrv*.exe is doing, as a service, that is blocking contig.
>
> http://technet.microsoft.com/en-ca/sysinternals/bb897428.aspx
>
> Breck
>
>
>
> Personally, I do not use contig.exe in production environments, nor do
> I recommend it, simply because it is delivered "as is"
>
>
> On 27 Mar 2009 09:58:31 -0800, <Ingmar> wrote:
>
>>hello Breck,
>>thx for your answer.
>>I tried the procedure on an other PC and have the same problem.
>>contig hangs... but only when the server ist started as service.
>>On the first system its ok now... the second system has now the problem
>>and
>>i don't know where the difference is.
>>have u an idee why there ist sometimes a problem when the db-server runs
>>as
>>service with user "system"?
>>
>>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>>Newsbeitrag news:39fis4988sr8o331bfvu291t52ek6c968d@4ax.com...
>>>I have had no problems running contig.exe or Diskeeper on active
>>> databases. I believe it is important to keep those programs up to date
>>> with respect to operating systems. In other words, I would be
>>> uncomfortable running old versions of either on a brand-new version of
>>> Windows. FWIW I am a HUGE fan of Diskeeper... and I have a lot more
>>> experience with it than contig.exe for the simple reason that it has a
>>> much higher level of automation (i.e., I leave it running 24 x 365).
>>>
>>> With Diskeeper, you could simply grow the file, then let Diskeeper
>>> defrag when it gets around to it (screensaver mode is nice).
>>>
>>> Defragmenting the db is very important, the temp file important (but
>>> arguably less important than the db), and the log file not so
>>> important. The log file is written sequentially, and AFAIK only
>>> dbremote.exe and dbmlsync.exe read it (in the normal case, when you
>>> aren't recovering from disaster :)
>>>
>>> Breck
>>>
>>>
>>> On 24 Mar 2009 06:23:19 -0800, <Ingmar> wrote:
>>>
>>>>Hello Breck!
>>>>
>>>>I don't know why, but after a few tests with various settings, it is
>>>>running
>>>>now ... in the original version.
>>>>
>>>>But I have another question ... is it possible / allowed to defragment
>>>>(with
>>>>contig.exe) a running database-file (engine) or the log-file of a
>>>>running
>>>>database?
>>>>Sense is to check in a certain time interval whether the level of free
>>>>pages
>>>>below a certain limit is. If this occurs, the DB-space will enlarged and
>>>>then (in started mode) defragmented.
>>>>
>>>>Ingmar
>>>>
>>>>
>>>>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>>>>Newsbeitrag news:8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com...
>>>>> Is the SQL Anywhere engine running as a service, or is an ordinary
>>>>> "desktop" application? If it is a service, can you try it as a desktop
>>>>> app (JUST to narrow down the cause).
>>>>>
>>>>> What Operating System are you using? e.g., XP, RedHat, etc.
>>>>>
>>>>> Assuming Windows: What does Task Manager say? Does anything show up in
>>>>> the Windows error logs?
>>>>>
>>>>> FYI I wrote an article about it here
>>>>> http://sqlanywhere.blogspot.com/2008/02/defragmenting-temporary-file.html
>>>>>
>>>>> Breck
>>>>>
>>>>> On 20 Mar 2009 08:35:34 -0800, ingmar.beck@eccos-pro.com wrote:
>>>>>
>>>>>>Hi!
>>>>>>When I wanted to implement the tip "How do I ensure the
>>>>>>temporary dbspace remains contiguous?" of B. Carter, there
>>>>>>was a problem. The process "contig.exe" suspended. If
>>>>>>contig.exe is started, the output file is created.
>>>>>>Otherwise, nothing happens.
>>>>>>Tested with ASA 9.0.2 and 11.0.1.
>>>>>>I used "contig.exe" in the current version (1.55).
>>>>>>Other commands are running with "CALL xp_cmdshell" without
>>>>>>problems. Even another defragmentation tool (JkDefrag)
>>>>>>works.
>>>>>>Where could the problem be?
>>>>>
>>>>> --
>>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>>
>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>> breck.carter@risingroad.com
>>>>>
>>>>
>>>
>>> --
>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>
>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>> breck.carter@risingroad.com
>>>
>>
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com
>


Breck Carter [TeamSybase] Posted on 2009-03-30 12:30:15.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: Solution: Problem with contig.exe and CALL xp_cmdshell
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <ope1t4h0pmvfma6fsrdmhjilvbsjcuaiar@4ax.com>
References: <49c3c5d6.732d.1681692777@sybase.com> <8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com> <49c8ecd7@forums-1-dub> <39fis4988sr8o331bfvu291t52ek6c968d@4ax.com> <49cd13c7@forums-1-dub> <1spus41767gkavqmasvrp60rl2ms9fsmm2@4ax.com> <49d0b4bc@forums-1-dub>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 30 Mar 2009 04:30:15 -0800
X-Trace: forums-1-dub 1238416215 10.22.241.152 (30 Mar 2009 04:30:15 -0800)
X-Original-Trace: 30 Mar 2009 04:30:15 -0800, vip152.sybase.com
Lines: 161
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7455
Article PK: 5868

...and thank YOU very much for taking the time to post the solution!

Breck

On 30 Mar 2009 04:02:04 -0800, <Ingmar> wrote:

>Hi Breck,
>
>I added a topic in the "Sysinternals Utilities Forum and now I have the
>solution.
>>> I need an additional switch "/accepteula" to accept the EULA acceptance
>>> dialog.
>
>It seems to be a problem / a feature of the current version (1.55).
>
>Thank you for your efforts and your patience ;-)
>Ingmar
>
>
>
>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>Newsbeitrag news:1spus41767gkavqmasvrp60rl2ms9fsmm2@4ax.com...
>>I apologize if you have already answered these questions:
>>
>> Have you downloaded the most recent version of contig.exe?
>>
>> Have you tried launching contig.exe via xp_cmdshell from inside the
>> running engine? I don't know if that will work at all, let alone solve
>> your problem, but it might change the security attributes of the
>> environment contig is running in... if that is the problem.
>>
>> Have you tried asking the author? It's one guy, I'm not sure how to
>> reach him, but he is universally well-liked. There may be something
>> that dbsrv*.exe is doing, as a service, that is blocking contig.
>>
>> http://technet.microsoft.com/en-ca/sysinternals/bb897428.aspx
>>
>> Breck
>>
>>
>>
>> Personally, I do not use contig.exe in production environments, nor do
>> I recommend it, simply because it is delivered "as is"
>>
>>
>> On 27 Mar 2009 09:58:31 -0800, <Ingmar> wrote:
>>
>>>hello Breck,
>>>thx for your answer.
>>>I tried the procedure on an other PC and have the same problem.
>>>contig hangs... but only when the server ist started as service.
>>>On the first system its ok now... the second system has now the problem
>>>and
>>>i don't know where the difference is.
>>>have u an idee why there ist sometimes a problem when the db-server runs
>>>as
>>>service with user "system"?
>>>
>>>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>>>Newsbeitrag news:39fis4988sr8o331bfvu291t52ek6c968d@4ax.com...
>>>>I have had no problems running contig.exe or Diskeeper on active
>>>> databases. I believe it is important to keep those programs up to date
>>>> with respect to operating systems. In other words, I would be
>>>> uncomfortable running old versions of either on a brand-new version of
>>>> Windows. FWIW I am a HUGE fan of Diskeeper... and I have a lot more
>>>> experience with it than contig.exe for the simple reason that it has a
>>>> much higher level of automation (i.e., I leave it running 24 x 365).
>>>>
>>>> With Diskeeper, you could simply grow the file, then let Diskeeper
>>>> defrag when it gets around to it (screensaver mode is nice).
>>>>
>>>> Defragmenting the db is very important, the temp file important (but
>>>> arguably less important than the db), and the log file not so
>>>> important. The log file is written sequentially, and AFAIK only
>>>> dbremote.exe and dbmlsync.exe read it (in the normal case, when you
>>>> aren't recovering from disaster :)
>>>>
>>>> Breck
>>>>
>>>>
>>>> On 24 Mar 2009 06:23:19 -0800, <Ingmar> wrote:
>>>>
>>>>>Hello Breck!
>>>>>
>>>>>I don't know why, but after a few tests with various settings, it is
>>>>>running
>>>>>now ... in the original version.
>>>>>
>>>>>But I have another question ... is it possible / allowed to defragment
>>>>>(with
>>>>>contig.exe) a running database-file (engine) or the log-file of a
>>>>>running
>>>>>database?
>>>>>Sense is to check in a certain time interval whether the level of free
>>>>>pages
>>>>>below a certain limit is. If this occurs, the DB-space will enlarged and
>>>>>then (in started mode) defragmented.
>>>>>
>>>>>Ingmar
>>>>>
>>>>>
>>>>>"Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com> schrieb im
>>>>>Newsbeitrag news:8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com...
>>>>>> Is the SQL Anywhere engine running as a service, or is an ordinary
>>>>>> "desktop" application? If it is a service, can you try it as a desktop
>>>>>> app (JUST to narrow down the cause).
>>>>>>
>>>>>> What Operating System are you using? e.g., XP, RedHat, etc.
>>>>>>
>>>>>> Assuming Windows: What does Task Manager say? Does anything show up in
>>>>>> the Windows error logs?
>>>>>>
>>>>>> FYI I wrote an article about it here
>>>>>> http://sqlanywhere.blogspot.com/2008/02/defragmenting-temporary-file.html
>>>>>>
>>>>>> Breck
>>>>>>
>>>>>> On 20 Mar 2009 08:35:34 -0800, ingmar.beck@eccos-pro.com wrote:
>>>>>>
>>>>>>>Hi!
>>>>>>>When I wanted to implement the tip "How do I ensure the
>>>>>>>temporary dbspace remains contiguous?" of B. Carter, there
>>>>>>>was a problem. The process "contig.exe" suspended. If
>>>>>>>contig.exe is started, the output file is created.
>>>>>>>Otherwise, nothing happens.
>>>>>>>Tested with ASA 9.0.2 and 11.0.1.
>>>>>>>I used "contig.exe" in the current version (1.55).
>>>>>>>Other commands are running with "CALL xp_cmdshell" without
>>>>>>>problems. Even another defragmentation tool (JkDefrag)
>>>>>>>works.
>>>>>>>Where could the problem be?
>>>>>>
>>>>>> --
>>>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>>>
>>>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>>>> breck.carter@risingroad.com
>>>>>>
>>>>>
>>>>
>>>> --
>>>> Breck Carter http://sqlanywhere.blogspot.com/
>>>>
>>>> RisingRoad SQL Anywhere and MobiLink Professional Services
>>>> breck.carter@risingroad.com
>>>>
>>>
>>
>> --
>> Breck Carter http://sqlanywhere.blogspot.com/
>>
>> RisingRoad SQL Anywhere and MobiLink Professional Services
>> breck.carter@risingroad.com
>>
>

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com


Ingmar Posted on 2009-03-23 09:46:53.0Z
Sender: 18c8.49c756c1.1804289383@sybase.com
From: Ingmar
Newsgroups: ianywhere.public.general
Subject: Re: Problem with contig.exe and CALL xp_cmdshell
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49c75a8d.196b.1681692777@sybase.com>
References: <8179s4ps9b18b1517vv7s94np6te0m7al6@4ax.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 23 Mar 2009 01:46:53 -0800
X-Trace: forums-1-dub 1237801613 10.22.241.41 (23 Mar 2009 01:46:53 -0800)
X-Original-Trace: 23 Mar 2009 01:46:53 -0800, 10.22.241.41
Lines: 52
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7426
Article PK: 5844

Hello Breck!
The engine ist running as service. i will try it as desktop
app in the next days.

I'm using Xp prof with SP2.
In the Task Manager there is an entry fpr contig.exe... but
no CPU-Aktivity ist shown.
There is no entry in the Windows error-logs (app and system)

I know your article here and tried it, as you've described
it.
I'm especially surprised that the output file created by
contig.exe completely empty is.

> Is the SQL Anywhere engine running as a service, or is an
> ordinary "desktop" application? If it is a service, can
> you try it as a desktop app (JUST to narrow down the
> cause).
>
> What Operating System are you using? e.g., XP, RedHat,
> etc.
>
> Assuming Windows: What does Task Manager say? Does
> anything show up in the Windows error logs?
>
> FYI I wrote an article about it here
>
http://sqlanywhere.blogspot.com/2008/02/defragmenting-temporary-file.html
>
> Breck
>
> On 20 Mar 2009 08:35:34 -0800, ingmar.beck@eccos-pro.com
> wrote:
>
> >Hi!
> >When I wanted to implement the tip "How do I ensure the
> >temporary dbspace remains contiguous?" of B. Carter,
> there >was a problem. The process "contig.exe" suspended.
> If >contig.exe is started, the output file is created.
> >Otherwise, nothing happens.
> >Tested with ASA 9.0.2 and 11.0.1.
> >I used "contig.exe" in the current version (1.55).
> >Other commands are running with "CALL xp_cmdshell"
> without >problems. Even another defragmentation tool
> (JkDefrag) >works.
> >Where could the problem be?
>
> --
> Breck Carter http://sqlanywhere.blogspot.com/
>
> RisingRoad SQL Anywhere and MobiLink Professional Services
> breck.carter@risingroad.com