Re: MaxDB performance versus Microsoft SQL performance

Another thing to try is to turn off auto-commit and commit the transaction at the end. Although this number of records may fill the transaction log and the inserts may need to be done in smaller chunks. Our application (not as many inserts) improved greatly by turning off auto-commit and comm

Automatic Extension

I have been searching for some documentation on the "automatic exension" feature in SAPDB/MAXDB but can only find a couple of messages on the mailing list. This is what I gathered: - The feature is turned on via: dbmcli> dbm_configset autoext on (I have done this, but have not filled a de

Re: Adding Dev Space after Database Full

F 200 Of course the best way to add a data volme is db_addvolume! Regards, Torsten SAP DB, SAP Labs Berlin -----Original Message- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Dienstag, 20. April 2004 02:08 To: Strahl, Torsten Cc: Open Source List Subject: Re: Adding Dev Space af

Re: Adding Dev Space after Database Full

e using 7.4.03. (Do you?) In 7.4.03 you have to call util_execute ADD DATA DEVSPACE 'd:\NetVoyant\db\nms2\datadev02' PAGES 100 DEVICE 2 instead of util_execute ADD DATA VOLUME 'd:\NetVoyant\db\nms2\datadev02' PAGES 100 DEVICE 2 Regards, Torsten SAP DB, SAP Labs Berl

Re: Adding Dev Space after Database Full

he following command: util_execute ADD DATA VOLUME 'D:\...\datadev02' PAGES 128000 DEVICE 2 Pay attention that the given data volume name has to be absolute identically with the volume name given at the param_addvolume command. Regards, Torsten SAP DB, SAP Labs Berlin -

Re: Adding Dev Space after Database Full

" because this interruptes your log backup history!!! Regards, Torsten SAP DB, SAP Labs Berlin -Original Message----- From: John L. Singleton [mailto:[EMAIL PROTECTED] Sent: Freitag, 16. April 2004 04:44 To: Mark Johnson Cc: Maxdb List Subject: Re: Adding Dev Space after Database Full Mark

Adding Dev Space after Database Full

I have had this problem before and received a few suggestions, but have not solved this problem yet. Our database fills and, in addition, there are many transactions in the transaction log. This prevents the database from comming up into warm mode (it halts while moving transactions to from t

Re: AW: embedded SAP DB / unattended installation

Alex, We do a similar procedure in a Linux RPM, Solaris package, and a Windows InstallShield script using method "a" below. The problem with method "b" is getting all the registry setting and file setting correct and updates when a version changes (many of the settings change). You also need

DB Crash

We have been having problems with the 7.4 build 17 version crashing about every two days, so I upgraded to 7.4 build 30 (Windows 2000). Today we got another crash, but it appears different than the others. Below is a section of knldiag. Can anyone help? Thanks in advance, Mark ... 2004-01-28

Re: SAPDB Crash

Marco, Ignore the last message - I had a configuration file pointing to the wrong driver. After changing the id/password to upper case, the connection works. Thanks again, Mark Mark Johnson wrote: Marco, Thanks for the information. I've upgraded to the latest 7.4 version below, but

Re: SAPDB Crash

r as I remember also this one that you are running into. Please let me know if the error still occurs with the new driver. regards, Marco -Original Message----- From: Mark Johnson [mailto:[EMAIL PROTECTED] Sent: Freitag, 23. Januar 2004 00:15 To: Schroeder, Alexander; [EMAIL PROTECTED] Sub

Re: SAPDB Crash

ne or what it was doing. Typically our apps read, write and update statistical data throughout the day. Thanks for your help, Mark Johnson Schroeder, Alexander wrote: Hello Mark, can you tell us what the client application did when this error happened. As the knldiag also suggests you are wo

SAPDB Crash

Does anyone know what this crash information means? TIA, Mark 2004-01-20 15:26:27 0x6CC 19677 CONNECT Client has released connection, T61 2004-01-20 15:26:27 0x6CC 19651 CONNECT Connection released, T61 2004-01-20 15:30:08 0x6CC 19633 CONNECT Connect req. (T61, Node:'

Kernel Abort

I had a kernel abort last night. Attched is part of the knldiag.err file. I have the other files as well and some other interesting files were generated that I haven't seen before: AK.dmp AK.stm dbm.utl rtedump The program that caused the problem was performing some major queries in the datab

Re: AW: DB Full - Crash on startup

Here's the latest - still no luck.. --- dbmcli on nms2>db_state OK State ADMIN --- dbmcli on nms2>param_startsession OK --- dbmcli on nms2>db_addvolume DATA c:\netvoyant\db\nms2\datadev02 F 64 ERR -24974,ERR_XPSESSION: param session active dbmcli on nms2>db_stop ERR -24994,ERR_RTE: runtime env

Re: Sample format for DATALOAD input files?

Here's one of our examples with a comma separator. We screwed around awhile to get it to work (it was the loader syntax). Here's the table and the DATALOAD command: CREATE TABLE proto_groupings ( protocol_id intNOT NULL DEFAULT SERIAL (1) primary key, short_name char(32)

Re: AW: DB Full - Crash on startup

hings. Then you confirm your settings with . When this volume is created your database can be started in Online-Mode. -Ursprüngliche Nachricht- Von: Mark Johnson [SMTP:[EMAIL PROTECTED] Gesendet am:Mittwoch, 10. Dezember 2003 00:00 An: [EMAIL PROTECTED] Cc: [EMAIL PROT

DB Full - Crash on startup

It seems our database filled and cannot get to online mode. The following message is found in knldiag: 2003-12-09 16:31:2936 WNG18 Log Log backups are disabled 2003-12-09 16:31:2936 7 Log 1 queues, flushmode is 'MinimizeSpace', devstate is 'HistoryLost' 2003-12-09

Re: Insert performance on large table

great tool for figuring out which resources are being consumed. Regards, Mark Javier Gostling wrote: On Mon, Nov 10, 2003 at 09:42:08AM -0600, Mark Johnson wrote: We did two things that significantly improved our insert performance. The first was putting a transaction around the entire i

Re: Insert performance on large table

We did two things that significantly improved our insert performance. The first was putting a transaction around the entire insert process and committing the transaction at the end (this has been documented in this list several times before). The second was to perform the inserts in "bulk" mo

Re: Yet more bugs

I have reported the same problem a couple of months ago and I'm working with Wolfgang to troubleshoot and resolve this problem (Windows wahttp issue with websql). Mark Ulrich Stärk wrote: Hi list, Here are some bugs I experienced: WebTools: - waadmin.wa is not asking for a username and passw

Bad Computer Crash

We had a computer running SAPDB lose power while the database was running and we cannot get the database back into admin mode. When doing the following command: dbmcli -d... -u... db_admin We get: -24994, RTE_ERR: Runtime Environment Error -2, Kernel start failed. I'm guessing that the tran

Re: several transactions on various threads within one application

Does the same constraints (???) apply to the ODBC driver? i.e., - what we want to do is share a single connection with multiple threads. Each thread creates its own statement handles, etc. from the shared connection. Is the ODBC driver (with a shared connection handle) thread safe? Or is th

Re: websql

. Thanks, Mark Auer, Wolfgang wrote: Hi Mark, I cannot reproduce this error on Win 2000. Is it possible the I send you a debug version which writes a trace file? When websql crashes do you get any log file from the system debugger? Regards Wolfgang -Original Message- From: Mark Johnson

websql

I have downloaded the lastest version of SAPDB, removed all the old software and re-installed. I still cannot get websql to work on Windows 2000 ( the web server aborts on an access violation). Awhile back when I first reported this, some said there may be a debug version of the program so I