About Breck_Carter

Breck_Carter

...this is why everyone should keep a copy of the local HTML Help 

Breck_Carter · Is dynamic tuning of the MPL no longer safe in SQL Anywhere 17.0.10.6089?

Question 1: What do all the values in thie SQL Anywhere 17.0.10.6089 message mean? I. MPL[curr=80 prev=80] concurrency[213] throughput[curr=5 prev=4573] algorithm=0 It appeared at the beginning of a 46.8 second outage where SQL Anywhere skyrocke...

Breck_Carter

Observations indicate PROPERTY ( 'CurrentMultiProgrammingLevel' ) is exactly the same as PROPERTY ( 'MultiProgrammingLevel' ).

Breck_Carter

dbsrv17 -gnh 20 works, but CALL sa_server_option ( 'MaxMultiProgrammingLevel', '20' ); doesn't work for any value less than 80... Could not execute statement. Invalid setting for option 'MaxMultiProgrammingLevel' SQLCODE=-201, ODBC 3 State="42000" Li...

Breck_Carter

I have seen assertion 108803 at two different locations in the same long-running I/O bound program in the past month. It goes away when the program is re-run. 2022 03 30 occurrence... 2022-03-30 16:21:59.205 DATA UPGRADE: Copying all of table 34 of ...

Breck_Carter

Perhaps a week is a week, not just the number of days divided by seven  Specifying Date Parts 1-54. Weeks begin on Sunday. A 54-week year occurs in leap years that start on a Saturday. Week is not subject to the first_day_of_week setting.

Breck_Carter

> Are you saying that a full unload/reload will not work? No, I'm not saying that. If a full unload/reload does work, it's probably safe to say the fresh new *.db file is completely OK.

Breck_Carter

> Had this error Exactly when/where did you see this message? When trying to start the database? When running a query? > I'm running a VALIDATE on the tables now Presumably you are able to start database. You may be able to isolate the table by doing...

Breck_Carter

> is there a simpler solution No... the string concatenation operator is going to change a NULL operand into '', which is what most folks want. It will not change a NULL operand into the 'NULL' string value without specific instructions ( if tel is N...

Breck_Carter · Re: Is dynamic tuning of the MPL no longer safe in SQL Anywhere 17.0.10.6089?

Here's what the Help says about thread deadlock: "The design of your application may also cause thread deadlock because of excessive or unintentional contention. In these cases, scaling the application to larger data sets can make the problem worse, ...

User Statistics

User Activity

Heads up: The SAP SQL Anywhere help portal is unstable

Is dynamic tuning of the MPL no longer safe in SQL Anywhere 17.0.10.6089?

Is CurrentMultiProgrammingLevel the same as MultiProgrammingLevel?

Why does CALL sa_server_option ( 'MaxMultiProgrammingLevel', '20' ); fail?

What causes Assertion failed 108803 File pointer moved unexpectedly?

Re: Why does datepart return weeks from 1-54?

Re: Assertion failed: 200166

Re: Assertion failed: 200166

Re: create sql statement using unload statement

Re: Is dynamic tuning of the MPL no longer safe in SQL Anywhere 17.0.10.6089?