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.

What does the startup par -T8203 mean in registry

8 posts in Windows NT Last posting was on 2001-05-30 08:04:32.0Z
Geoff_Smith Posted on 2001-05-28 08:00:08.0Z
From: Geoff_Smith
Date: Mon, 28 May 2001 04:00:08 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: What does the startup par -T8203 mean in registry
Message-ID: <EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums>
Lines: 19
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.nt:691
Article PK: 1087298

Hello,

I can't find where this parameter is mentioned fopr NT ASE 11.9.2

What does the startup par -T8203 mean in registry

It is against arg5 for the main sqlserver (not backup)

Would someone please tell me what it means and where to find the full list
of startup parameters.

Also, if anyone know what the 4GT option enabled in the winNT boot.ini
option enabled means in reference to RAM and/or multiprocessors I think.

Thanks,

Geoff


Jim Egan Posted on 2001-05-29 05:23:52.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: What does the startup par -T8203 mean in registry
Date: Mon, 28 May 2001 23:23:52 -0600
Message-ID: <MPG.157ce05215380ccb98b3c2@forums.sybase.com>
References: <EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 14
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:684
Article PK: 1087291


Geoff_Smith wrote...
> Also, if anyone know what the 4GT option enabled in the winNT boot.ini
> option enabled means in reference to RAM and/or multiprocessors I think.
>

My understanding is that this allows a single NT process/application to access more than
2GB of RAM. You would need NT Enterprise to enable this. I thought it was 3GT though.
--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Sybase TechWave 2001 http://www.sybase.com/events/techwave2001
August 12th - 16th, San Diego


Geoff_Smith Posted on 2001-05-29 06:18:05.0Z
From: Geoff_Smith
Date: Tue, 29 May 2001 02:18:05 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: What does the startup par -T8203 mean in registry
Message-ID: <11FC87FAFA11C41E00229D7B85256A5B.00228B6785256A5B@webforums>
References: <EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums> <MPG.157ce05215380ccb98b3c2@forums.sybase.com>
Lines: 17
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.nt:682
Article PK: 1087292

Jim,

So if you only have NT server you can't use it?

If you don't set this option does that mean you have to set total memory
below 1024000 pages, because I had a problem today (see other postings) re:
this issue, however I was considering using the lock shared memory option,
because it appears NT got into the shared memory and caused a problem.

I suspect this because the info on avaiable and used memory in task manager
was showing totally different values before and after the big "churn-up" of
memory that meant no new processes could start, existing ones seemed ok,
and db recovered 100% on reboot.

Cheers,

Geoff


Jim Egan Posted on 2001-05-29 14:47:42.0Z
From: Jim Egan <dbaguru@eganomics.com>
Subject: Re: What does the startup par -T8203 mean in registry
Date: Tue, 29 May 2001 08:47:42 -0600
Message-ID: <MPG.157d6477ef01d8f998b3c6@forums.sybase.com>
References: <EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums> <MPG.157ce05215380ccb98b3c2@forums.sybase.com> <11FC87FAFA11C41E00229D7B85256A5B.00228B6785256A5B@webforums>
Reply-To: eganjp@compuserve.com
X-Newsreader: MicroPlanet Gravity v2.50
Newsgroups: sybase.public.sqlserver.nt
Lines: 19
NNTP-Posting-Host: c1420400-b.hiland1.co.home.com 65.7.153.228
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:679
Article PK: 1087286


Geoff_Smith wrote...
> Jim,
>
> So if you only have NT server you can't use it?
>
> If you don't set this option does that mean you have to set total memory
> below 1024000 pages, because I had a problem today (see other postings) re:
> this issue, however I was considering using the lock shared memory option,
> because it appears NT got into the shared memory and caused a problem.
>

That is my understanding. But I haven't had the opportunity to run a server with NT
Enterprise and more than 2GB of RAM. So I haven't experimented with this myself.

--
Jim Egan [TeamSybase]
Senior Consultant
Sybase Professional Services

Sybase TechWave 2001 http://www.sybase.com/events/techwave2001
August 12th - 16th, San Diego


Rob Verschoor Posted on 2001-05-28 17:24:12.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums>
Subject: Re: What does the startup par -T8203 mean in registry
Date: Mon, 28 May 2001 19:24:12 +0200
Lines: 44
Organization: Sypron B.V.
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <ry79d355AHA.293@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i0460.pvu.euronet.nl 194.134.165.205
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:690
Article PK: 1087295


<Geoff_Smith> wrote in message
news:EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums...
> Hello,
>
> I can't find where this parameter is mentioned fopr NT ASE 11.9.2
>
> What does the startup par -T8203 mean in registry
>
> It is against arg5 for the main sqlserver (not backup)
>
> Would someone please tell me what it means and where to find the
full list
> of startup parameters.
>
> Also, if anyone know what the 4GT option enabled in the winNT
boot.ini
> option enabled means in reference to RAM and/or multiprocessors I
think.
>
> Thanks,
>
> Geoff
>

It means the server is started with traceflag 8203; this traceflag
displays details about locking issues whenever a deadlock occurs.

HTH,

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

Certified Sybase Professional DBA for ASE 12.0/11.5/11.0

Author of "The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/qr

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


Geoff_Smith Posted on 2001-05-29 05:08:20.0Z
From: Geoff_Smith
Date: Tue, 29 May 2001 01:08:20 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: What does the startup par -T8203 mean in registry
Message-ID: <A16ED2CB7379C45D001C3AC885256A5B.0061E60985256A5A@webforums>
References: <EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums> <ry79d355AHA.293@forums.sybase.com>
Lines: 17
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.nt:685
Article PK: 1087289

Rob,

Thanks, I did think that's what it was, but i couldn't find it in the
manuals. It was the only "extra" thing I had "turned on" in the config
file.

Thanks for the ref to your book, I did forward it to the boss, you never
know....

By the way, I would appreciate input on the 3 errors above this posting (I
have seemed to resolve the log dump error, so it is not as important at
present, but I'm interested to know what caused it (bad diskinit maybe, it
is an old device attached to the db way way before I got here, and I
extended the log onto it to see if it was usable) and got the error at the
next tran dump)

Thanks,

Geoff


Rob Verschoor Posted on 2001-05-29 17:30:54.0Z
Reply-To: "Rob Verschoor" <rob@sypron.nl>
From: "Rob Verschoor" <rob@sypron.nl>
References: <EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums> <ry79d355AHA.293@forums.sybase.com> <A16ED2CB7379C45D001C3AC885256A5B.0061E60985256A5A@webforums>
Subject: Re: What does the startup par -T8203 mean in registry
Date: Tue, 29 May 2001 19:30:54 +0200
Lines: 29
Organization: Sypron B.V.
MIME-Version: 1.0
Content-Type: text/plain; charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <Z4x6EhG6AHA.261@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: i0390.pvu.euronet.nl 194.134.165.135
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:677
Article PK: 1087284


<Geoff_Smith> wrote in message
news:A16ED2CB7379C45D001C3AC885256A5B.0061E60985256A5A@webforums...
> Rob,
>
> Thanks, I did think that's what it was, but i couldn't find it in
the
> manuals. It was the only "extra" thing I had "turned on" in the
config
> file.
>
> Thanks for the ref to your book, I did forward it to the boss, you
never
> know....
>
> By the way, I would appreciate input on the 3 errors above this
posting (I
> have seemed to resolve the log dump error, so it is not as important
at
> present, but I'm interested to know what caused it (bad diskinit
maybe, it
> is an old device attached to the db way way before I got here, and I
> extended the log onto it to see if it was usable) and got the error
at the
> next tran dump)

Which errors are you referring to here ?

Rob V.


Geoff_Smith Posted on 2001-05-30 08:04:32.0Z
From: Geoff_Smith
Date: Wed, 30 May 2001 04:04:32 -0400
Newsgroups: sybase.public.sqlserver.nt
Subject: Re: What does the startup par -T8203 mean in registry
Message-ID: <18098D6ADC98F1D7002C5C4B85256A5C.0063009985256A5B@webforums>
References: <EF5988C93BE51E98002BF50F85256A5A.002BF52085256A5A@webforums> <ry79d355AHA.293@forums.sybase.com> <A16ED2CB7379C45D001C3AC885256A5B.0061E60985256A5A@webforums> <Z4x6EhG6AHA.261@forums.sybase.com>
Lines: 75
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.nt:675
Article PK: 1087283

WHAT IS THIS ERROR: 1603

02:00000:00003:2001/05/29 09:18:48.15 server Error: 1603, Severity: 21,
State: 2
02:00000:00003:2001/05/29 09:18:48.15 server Process priority 3 invalid or

no process slots available
00:00000:00003:2001/05/29 09:18:48.79 kernel NT operating system error 8
in module 'e:\rel1192\porttree\svr\sql\nt386\ksource\proc\prcontext.c' at
line 318: Not enough storage is available to process this command.

Background:

Machine: compaq proliant 4cpu 3300M RAM

I set pagefile to 4000M
set shared mem starting address to: 23662592 from 0
set total memory to 1024000 (2000M) from 700000

Got this error and had to shutdown after 1 hour of new settings.

ANY IDEAS, I have changed the setting back to pre change (0 / 700000)

Geoff

In NT what is the 4GT option enabled mean in ref. to Sybase




Guys and Girls,


Remember Justin Largent?? was increasing his Sybase memory and said in NT
he had the 4GT option enable in the boot.ini in referenc to hi compaq
proliant 4cpu 4GB ram macine.

Question:

What is he talking about, I don't know what this option is (nor does my NT
person), please explain.

Cheers,

Geoff



HELP with Log dump error





Would anyone please help with this error


Msg 692, Level 20, State 1:
Procedure 'sp__dumptrans', Line 30:
Uninitialized logical page '9259007' was read while accessing object '8' in
database '6'. Please contact Sybase Technical Support.
The SQL Server is terminating this process.


Thanks,

Geoff