Dear All, I am trying to get the best performance of my DB SQLA: dbsrv7.exe -q -c 25P -x tcpip does the above line enough? .. if I put -ca 0 and...

Winanjaya

05-06-2009 01:31 AM
Winanjaya

ASA 9.0.2.3554 I see the force index hints in the online documentation, but is there a way to for a sequential scan? I've got a query that's...

Tony Lanzel

05-05-2009 04:37 PM
Glenn Paulley [Sybase iAnywhere]

We are going through a PAPB/PCI compliance review and we use SQL Anywhere AES Encryption to store our credit card information. The auditor is...

Steve Garland [ASTA]

05-05-2009 03:57 PM
Josh Savill [Sybase]

I am getting a sytax error on the statement below. Can someone PLEASE tell me What's wrong with it? FOR monloop2 AS MonCurs2 CURSOR FOR...

jcarlson

05-05-2009 01:33 PM
Nick Elson [Sybase iAnywhere]

We're using NHibernate as our O/R mapper in a current project and we've run into some performance problems with SQL Anywhere (we're using version...

Stefan

05-05-2009 11:19 AM
Breck Carter [TeamSybase]

Hi, I've triedto start a database from the network and it started succesfully. It doesn't function if I configure ASA as a service, but works from...

Giorgio Papagno

05-05-2009 09:11 AM
Nick Elson [Sybase iAnywhere]

Have finished the process of migrating our ASA6 database up to SQL Anywhere 11. I've noticed something now in SQL Anywhere 11. We have multiple...

Jeff Gibson

05-05-2009 04:28 AM
Breck Carter [TeamSybase]

I have an event that is scheduled to run every 15 minutes. At some point, the event will lock up and stop running. The database otherwise functions...

J Craig

05-05-2009 04:26 AM
Breck Carter [TeamSybase]

ASA 9.0.2.3702 Is it possible to use a database function in the column (or table) check constraint? I would like to constraint that a number is...

Ricardo

05-04-2009 04:52 PM
Ricardo

I have been attempting to use the following sort of thing in a script run in ISQL: INPUT INTO Owner.TableName( col1,co2,col3); value1, value2,...

Clive Collie

05-04-2009 09:28 AM
Nick Elson [Sybase iAnywhere]

The documentation indicates and my own testing shows that the use of AWE caching locks up whatever memory you specify with -c. What ever value you...

Kyle Danielson

05-04-2009 08:15 AM
Jeff Albion [Sybase iAnywhere]

In powerbuilder we use a ODBC connection. SQL Commands are seperated with a ; In dbisql you can use ; within the sql statement and at the end of...

ontsnapt

05-04-2009 07:47 AM
R. Pods

After re-reading your message, I see you're talking about Groups, not Users. I'm not sure if this is possible. If it is, I'm not sure how to do...

Herman Miller

05-02-2009 04:47 AM
Breck Carter [TeamSybase]

Hi all Sql Anywhere 11.0.1.2044 I have a query that I can't figure out. I need to list log delivery tickets (truck loads of trees) based on the...

James L. Blackburn

05-01-2009 06:19 PM
Paul Horan[Sybase]

SQL Anywhere 9.0.2.3804 Hi all, We use dbbackup -xo to truncate the transaction log at customer sites when they start to run out of disk space and...

Shao Chan

05-01-2009 05:40 AM
lollypop.7@gmail.com

Hi I am using SqlAnywhere version 11.0.1.2044 and I am experiencing an error which attemption to use the following connection string within a .NET...

Ralph

04-30-2009 02:10 PM
Nick Elson [Sybase iAnywhere]

The documentation states that the maximum non AWE cache size is 2.7 Gb. If I use a -c 4096M parameter with no -cw, the server will indicate that it...

Kyle Danielson

04-30-2009 01:23 PM
John Smirnios [Sybase]

Greetings, ASA 9.0.2.3632. A simple SELECT * FROM table WHERE column LIKE '2009-04-30 %' is not picking up the index created on "column". There's...

Pavel Karady

04-30-2009 09:10 AM
Breck Carter [TeamSybase]

Hi, Environment: Ubuntu 8.04 64bit SQLAnywhere V11.0.1.2044 64bit unixODBC We are currently running our DB servers on Netware, we are planning...

springbok

04-30-2009 07:26 AM
Ray Ruvinskiy [Sybase iAnywhere]

Engine ver 9.0.2.3361 running on Win2003 server, sp2 SCJview ver is below, running on WinXP SP3, java ver 1.6.0_11. I was closing out scjview after...

04-29-2009 05:07 PM

In the process of moving our database from ASA6 up to SQL Anywhere 11, I've run across some switches that I can't find any documentation on. When I...

Jeff Gibson

04-29-2009 11:42 AM
Jeff Gibson

Does any one know why we're seeing I/O writes going up and down using Window task manger for dbsrv10.exe process but when we're using SQL Anywhere...

Rachan Terrell

04-28-2009 12:43 PM
Josh Savill [Sybase]

Hi, Our client has 15 remote databases replicating to one consolidated database. They are all using Sybase SQL Anywhere 9.0.2.3221. However one of...

Steven McAra

04-28-2009 11:58 AM
Nick Elson [Sybase iAnywhere]

X86 Update of 11.0.0 to 11.0.1 was released 03 Mar 2009 Update of 11.0.0 to build 1598 was released 23 Apr 2009 Should 11.0.0 to build 1598 be...

Charles.Gogolin@stanleyassociates.com

04-28-2009 08:10 AM
Josh Savill [Sybase]

Hi, using SQL Anywhere 9.0.2.3420 on Windows XP SP3, 384 MB RAM. I. 04/27 08:33:36. Note: The size of 'X:\Sql\Data\xxx_yyyy.db' is larger than...

Veselin Ivanov

04-27-2009 11:46 AM
Veselin Ivanov

Sybase 9.0.2.3534 How can I check on the status of database events including what events are running, success and failure of events run and any...

Herman Miller

04-27-2009 10:40 AM
Nick Elson [Sybase iAnywhere]

Hi all, i am sorry if this question seems silly. Actually I am a DBA and what I am looking for is to connect different RDMS using my Nokia mobile...

mobilecrazy

04-27-2009 09:59 AM
mobilecrazy

I am using version 11.0.1.2044 of SQL Anywhere. I have a database which is 103MB in size in which I truncated a number of tables that contained the...

Ralph

04-27-2009 09:57 AM
Kory Hodgson [Sybase iAnywhere]

First of all, I need to work with both databases - SA11 and ASE 15.0.3. Yesterday I get the last EBF for ASE client tools (ESD #17) and it has Sybase...

George Brink

04-27-2009 08:47 AM
Nick Elson [Sybase iAnywhere]

I am looking for suggestions on the best way to do something. First a little background: our application stores information on gas stations in a...

04-27-2009 08:41 AM
krisztian pinter

We are having a problem connecting to SQL ANYWHERE 11 with Powerbuilder 8 The SQL 11 odbc works fine for everything else, but when we try and use it...

powershop_nlw

04-25-2009 12:51 PM
Chris Keating [Sybase iAnywhere]

Hello, I have sql anywhere 9, 10 and 11 installed on my main development computer. It seems that when an SQL Anywhere 10 database is open with the...

Dave

04-24-2009 03:20 PM
Dave

In article <49f21244$1@forums-1-dub>, paulley (AT) ianywhere (DOT) com says... If the values are provided by an external application rather...

shubhas@gmail.com

04-24-2009 02:25 PM
Glenn Paulley [Sybase iAnywhere]

Did you remember to change the extension back to .reg? Ray wrote:

Chris Keating [Sybase iAnywhere]

04-24-2009 01:39 PM
Ray

My point of sale software uses sybase. I was checking out a customer and my battery back up died and the computer just shut off. When I got it...

Cindy

04-24-2009 09:18 AM
Josh Savill [Sybase]

A customer wants the following configuration. The database is on a network share (I know not recommended at all). He wants that the first user...

Arthur Hefti

04-24-2009 08:47 AM
Arthur Hefti

Greetings, a quickie, 11.0.1 maintenance upgrade - should be installed over 11.0.0 or can be used as a fresh install? Thanks in adv. Paulsson

Pavel Karady

04-24-2009 02:09 AM
Pavel Karady

Hello - I have installed SQL Anywhere 10 (from PB11 evaluation copy) and I do see scview.exe anymore. I do see scjview.exe ie. the Java-edition of...

04-23-2009 08:16 PM
Chris Keating [Sybase iAnywhere]

We have many apps that were created in .NET using the 'Any CPU' setting. When run on a 32 bit OS they run as 32 bit apps; when run on a 64 bit OS...

Dan Knight

04-22-2009 12:35 PM
Dan Knight

Hi, can anyone explain to me what reason might be behind the assertion: 101413 Unable to allocate a multi-page block of memory Thanks

M. Westphal

04-22-2009 12:34 PM
M. Westphal

We have a customer who had a "security" guy come in and they recommended we turn on the "-sb" switch when starting the database engine. We connect...

Bill Williams

04-22-2009 12:24 PM
Bill Williams

Hi all, I'm just testing the upgrade of a DB from ASA 8.0.3.5574 to 11.0.1.2052 on a WinXP box. Unloading with Sybase Central runs smoothly, but...

Volker Barth

04-22-2009 11:35 AM
Volker Barth

I am trying to create a new database in SQL ANYWHERE 11.0.1 and I am getting the following errors using the Create Database Wizard and I am getting...

Mark

04-22-2009 09:25 AM
Mark

Dietrich wrote: Also note that simply increasing the -gn setting has larger implications on memory allocation heuristics and performance of the...

Martin Schmeling

04-22-2009 09:07 AM
Jeff Albion [Sybase iAnywhere]

I am performing a daily backup of my database using the following event: CREATE EVENT evBackupDbFile SCHEDULE START TIME '00:00:01' EVERY 15...

bigtoe

04-22-2009 08:05 AM
bigtoe

Is the server running (must be running to be found using "Find Servers")? Where is the database (and server) relative to Sybase Cental i.e., same...

Chris Keating [Sybase iAnywhere]

04-22-2009 07:05 AM
Mark

Sybase 9.0.2.3534 How can I grant a user the ability to create and maintain users only? Thanks

Herman Miller

04-22-2009 02:28 AM
Volker Barth

Hi all, I have a query that execute successfully in production but now freezes. I have been able to pin point the condition where it fails but I...

kim_truongk@yahoo.com.au

04-20-2009 07:53 PM
kim_truongk@yahoo.com.au

I have to get the local time from a table which the UTC time was stored. Is there anyway or function I can do this with? I couldn't figure out...

Kevin

04-20-2009 03:33 PM
Kevin

I have used sybase SQL Anywhere to store data in java application. When i try to update data first time i am able to update data,but next time...

Hiren

04-20-2009 12:36 PM
Josh Savill [Sybase]