I get an error when I try this: update tbl_vendor set vendor_id = ROWNO + 1
Is there a way to us the ROWNO in a calculation such as this? Thanks, Scott Murray -----Original Message----- From: [EMAIL PROTECTED] [mailto:sapdb.general-admin@;listserv.sap.com]On Behalf Of [EMAIL PROTECTED] Sent: Monday, November 04, 2002 5:11 AM To: [EMAIL PROTECTED] Subject: sapdb.general digest, Vol 1 #585 - 11 msgs Send sapdb.general mailing list submissions to [EMAIL PROTECTED] To subscribe or unsubscribe via the World Wide Web, visit http://listserv.sap.com/mailman/listinfo/sapdb.general or, via email, send a message with subject or body 'help' to [EMAIL PROTECTED] You can reach the person managing the list at [EMAIL PROTECTED] When replying, please edit your Subject line so it is more specific than "Re: Contents of sapdb.general digest..." Today's Topics: 1. Missing DevTools source for instdbmsrv in CVS? (Jay Bonci) 2. Prepared Statements and integer columns (ajit_cus) 3. RE: definition of term "raw device" (Mensing, Joerg) 4. RE: What does the database during db_start db_warm? (Mensing, Joerg) 5. RE: strange problem with SQL-Studio (Auer, Wolfgang) 6. RE: SQL Studio - Catalog View (Auer, Wolfgang) 7. Log_mode (Mohamed Koker) 8. RE: Log_mode (Hahn, Uwe) 9. Restore instance under Windows (Mohamed Koker) 10. RE: Log_mode ([EMAIL PROTECTED]) 11. RE: Restore instance under Windows (Hahn, Uwe) --__--__-- Message: 1 From: "Jay Bonci" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Subject: Missing DevTools source for instdbmsrv in CVS? Date: Sun, 3 Nov 2002 08:11:08 -0500 This is a multi-part message in MIME format. ------=_NextPart_000_0076_01C28310.90B43600 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Hello there. I'm plugging along on a debian build still....I'm very = close, and will probably be assigning the official debian RFP bug to = myself for resolution. I have only this problem and a python libs error = I still need to work out, until more pop up ;) When dbm.mac builds on my machine with the DevTools CVS drop, I get an = error that it can't find instdbmsrv. In the DevTools binary = distribution, it looks like it is a pre-compiled ELF binary (and it can = execute it fine). Is this source missing from CVS? Thanks --jay ------=_NextPart_000_0076_01C28310.90B43600 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META http-equiv=3DContent-Type content=3D"text/html; = charset=3Diso-8859-1"> <META content=3D"MSHTML 5.50.4919.2200" name=3DGENERATOR> <STYLE></STYLE> </HEAD> <BODY bgColor=3D#ffffff> <DIV><FONT face=3DArial size=3D2>Hello there. I'm plugging along on a = debian build=20 still....I'm very close, and will probably be assigning the official = debian RFP=20 bug to myself for resolution. I have only this problem and a python = libs=20 error I still need to work out, until more pop up ;)</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>When dbm.mac builds on my machine with = the DevTools=20 CVS drop, I get an error that it can't find instdbmsrv. In the = DevTools=20 binary distribution, it looks like it is a pre-compiled ELF binary = (and it=20 can execute it fine).</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Is this source missing from = CVS?</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2>Thanks</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2> =20 --jay</FONT></DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV> <DIV><FONT face=3DArial size=3D2></FONT> </DIV></BODY></HTML> ------=_NextPart_000_0076_01C28310.90B43600-- --__--__-- Message: 2 Subject: Prepared Statements and integer columns Date: Mon, 4 Nov 2002 10:02:01 +0530 From: "ajit_cus" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Hi, I seem unable to use ODBC Prepared statements to write data into columns of type INTEGER i.e. FIXED 20,0. I always get a --> -802 Invalid numeric input parameter value on executing the prepared statement. Should'nt the driver do appropriate conversions? Note: OS windows 2000 SQLMODE ORACLE ODBC version 2.0 The table creation statement was: CREATE TABLE TEST (c1 INTEGER) The code looks like this: int integerval=4321; retcode = SQLPrepare(m_stmt, (SQLCHAR *)"Insert into test values(?)", (SQLINTEGER)strlen("Insert into test values(?)")); retcode = SQLBindParameter(m_stmt, 1,SQL_PARAM_INPUT, SQL_C_SLONG, SQL_INTEGER, 0, 0, SQLPOINTER)&integerval, sizeof(integerval),0); retcode = SQLExecute(m_stmt); Mail me if you want my test program. Regards, Ajit --__--__-- Message: 3 From: "Mensing, Joerg" <[EMAIL PROTECTED]> To: "'Martin'" <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Subject: RE: definition of term "raw device" Date: Mon, 4 Nov 2002 09:18:22 +0100 Hi, since SAPDB does not use any feature of a filesystem for its volumes(alias devspaces) any kind of filesystem overhead including a buffer cache is just an overhead. SAPDB opens using O_SYNC, but O_DIRECT is not yet used. All Read/Write activity use Systempages which are aligned to 4KByte. The LINUX raw devices which are preferred are those 'unbuffered' /dev/raw/rawX. CU jrg > -----Original Message----- > From: Martin [mailto:mrogge@;froggy.com.au] > Sent: Samstag, 2. November 2002 05:54 > To: [EMAIL PROTECTED] > Subject: definition of term "raw device" > > > Hi, > > it has occurred to me that the term "raw device" can be > interpreted in > different ways under linux. There are buffered block devices > like /dev/hda, > /dev/scd0 etc. and in later kernels unbuffered devices like > /dev/raw/raw1 > etc. that may be bound to the same hardware. Those unbuffered devices > require a 512 byte alignment for memory and disk access. > > My question: can SAPDB use unbuffered devices for dev spaces, > and is it > advisable to use them? Thanks, > > cu Martin > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > --__--__-- Message: 4 From: "Mensing, Joerg" <[EMAIL PROTECTED]> To: "'[EMAIL PROTECTED]'" <[EMAIL PROTECTED]> Cc: =?iso-8859-1?Q?=27Koller_S=E9bastien=27?= <[EMAIL PROTECTED]> Subject: RE: What does the database during db_start db_warm? Date: Mon, 4 Nov 2002 09:35:03 +0100 Hi, SAPDB uses log devspaces and data devspaces. During 'db_warm' the restart is executed, which uses the log devspace to put itself in a transaction consistent state. If you stopped the database with 'db_stop' it is disrupted. If you use 'db_offline' it is shutdown orderly. This means that a 'db_stop' does NOT do an orderly shutdown, especially not writing a savepoint. The restart must now use the last savepoint found in LOG and REDO all transactions since last savepoint. The fills the database data cache with those pages, it was filled with during your first execution. This leads to the same execution times as if you would have executed your statement again. Bad for a benchmark... Look in http://www.sapdb.org/htmhelp/19/774939e5523668e10000000a114084/frameset.htm Select Functions for Database Operation where you find 'db_offline' and 'db_stop'. NOTE: db_stop should be used in COLD(Admin) mode only! CU jrg > -----Original Message----- > From: Koller S�bastien [mailto:Sebastien.Koller@;cpln.ch] > Sent: Freitag, 1. November 2002 16:28 > To: '[EMAIL PROTECTED]' > Subject: What does the database during db_start db_warm? > > > Hello, > > I would like to know what's happening when we execute this > command: db_start > and db_warm. > > This question comes from the following situation: We are > trying to do a > benchmark and here is the procedure: > > 1. db_start > 2. db_warm > 3. execute the query: select count(*) .... -> we get the > execution time (for > example 4 min.) > 4. execute a second time the same query: 56 sec. > 5. db_stop > 6. db_warm > 7. execute the query: select count(*) .... -> we get the > execution time 56 > sec (again!) > > I don't know why after a shutdown of the database(db_stop) > the query doesn't > take the same time than the first time we executed the > query?????????????? > > What does the database during a db_start and b_warm????? > Thanks, > S�bastien > > E-mail: [EMAIL PROTECTED] > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > --__--__-- Message: 5 From: "Auer, Wolfgang" <[EMAIL PROTECTED]> To: =?iso-8859-1?Q?=27Sven_K=F6hler=27?= <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: strange problem with SQL-Studio Date: Mon, 4 Nov 2002 10:00:46 +0100 Hi Sven, the user you created is EXCLUSIVE and can open only one connection to the Database. The "Create" - Dialogs of SQL Studio need to open an additional AutoCommitOff connection to the database to do all necessary SQL statements in one transaction. Use the alter user statement to make the user NOT EXCLUSIVE. regards Wolfgang -----Original Message----- From: Sven K�hler [mailto:skoehler@;upb.de] Sent: Samstag, 2. November 2002 00:34 To: [EMAIL PROTECTED] Subject: strange problem with SQL-Studio hi! i created a user via CREATE USER testuser PASSWORD pass RESOURCE and logged in with SQL Studio. i can create, alter, and delete tables via SQL-commands, but _not_ using SQL-Studio because the Menu-Items are all grayed. i'm using SQL-Studio 7.4.3.5 with SAPDB 7.3.0.29 Thx Sven _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general --__--__-- Message: 6 From: "Auer, Wolfgang" <[EMAIL PROTECTED]> To: "'Scott Mackenzie'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: SQL Studio - Catalog View Date: Mon, 4 Nov 2002 10:09:13 +0100 Hi, The Catalogview of SQL Studio needs a certain column in the "Tables" Table. If the select statement to check for this column fails you get mentioned error. Please execute this sql statement in a sql dialog window. SELECT TABLETYPE FROM DOMAIN.TABLES WHERE TABLENAME = 'TABLES' If it fails you should check if your systemtables are ok. regards Wolfgang -----Original Message----- From: Scott Mackenzie [mailto:samackenzie@;shaw.ca] Sent: Sonntag, 3. November 2002 07:45 To: [EMAIL PROTECTED] Subject: SQL Studio - Catalog View I'm a new user of SAP DB and I'm running into trouble with SQL Studio Catalog View. I've downloaded and installed SAP DB 7.3.00 for windows NT/2000 and I'm running it on Win XP. I can connect with SQL studio to my test database however I get an error message from Catalog Manager saying "SQL Studio does not support the catalog view when connected to databases prior to 7.3.0". Database Manager tells me that the version of my test database is 7.3.0.25. In SQL Studio I can use SQL dialog to create and query tables but the Catalog Manager menu, Visual Query and Form Dialog don't seem to be working properly. Any Idea's as to what could be wrong? It would be nice to have a visual representation of my tables and relationships. _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general --__--__-- Message: 7 To: [EMAIL PROTECTED] From: "Mohamed Koker" <[EMAIL PROTECTED]> Subject: Log_mode Date: Mon, 4 Nov 2002 02:24:09 -0700 Reply-To: "Mohamed Koker" <[EMAIL PROTECTED]> I have a process which needs to be run each night and essentially consists of deleting a number of tables and then repopulating them based on an number of XML files. I found that unless I set the log_mode to demo, I end up filling up my log device. I sometimes get the same problem if I execute a query with a lot of outer joins. I would like to be able to change the log mode to demo just before I execute this process and then revert to single or dual after this process executes. Can I accomplish this via SQL or do I need to use dbmcli and if so what is the relevant command I need to use ? Is there any other way of preventing the log device from being filled ? Cheers -Mohamed --__--__-- Message: 8 From: "Hahn, Uwe" <[EMAIL PROTECTED]> To: "'Mohamed Koker'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: Log_mode Date: Mon, 4 Nov 2002 10:51:38 +0100 Normally users want to backup the log for recovery purpose. This is supported by "autosave log" which must be enabled. This keeps the log volume(device) free for working. If for any reason the log and revovery ability does not interest, you can set the database permanently to the log mode DEMO or you can use another variant with "dbmcli -d ... -u ... util_execute set log mode demo" After this you can reenable the "normal" log mode with a complete data backup in admin(cold) mode. regards Uwe > -----Original Message----- > From: Mohamed Koker [mailto:Mohamed.Koker@;mentatsolutions.com] > Sent: Montag, 4. November 2002 10:24 > To: [EMAIL PROTECTED] > Subject: Log_mode > > > I have a process which needs to be run each night and > essentially consists > of deleting a number of tables and then repopulating them > based on an number > of XML files. > > I found that unless I set the log_mode to demo, I end up > filling up my log > device. I sometimes get the same problem if I execute a query > with a lot of > outer joins. > > I would like to be able to change the log mode to demo just > before I execute > this process and then revert to single or dual after this > process executes. > Can I accomplish this via SQL or do I need to use dbmcli and > if so what is > the relevant command I need to use ? > > Is there any other way of preventing the log device from > being filled ? > > Cheers > > -Mohamed > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > --__--__-- Message: 9 To: [EMAIL PROTECTED] From: "Mohamed Koker" <[EMAIL PROTECTED]> Subject: Restore instance under Windows Date: Mon, 4 Nov 2002 03:01:22 -0700 Reply-To: "Mohamed Koker" <[EMAIL PROTECTED]> I created a database instance on machine A, added some data, created a backup for migration, and used this to create a database instance on machine B by recovering the backup from machine A. So far, so good. My problem begins when I update the data on machine A, make a new backup and try to bring both machines into sync by restoring the new backup on machine B. This always fails at the point when I restart the database. The only way I have managed to bring the two databases into sync is by dropping the instance on machine B and recreating it based on the backup from machine A. This strikes me as more than a little odd. Can someone tell me what I am doing wrong ? Is there a step I am missing ? I am using 7.30.28 under Windows 2000 on both machines and am using the DBMGUI. Thanks in advance -Mohamed --__--__-- Message: 10 From: [EMAIL PROTECTED] To: "Hahn, Uwe" <[EMAIL PROTECTED]> Cc: [EMAIL PROTECTED] Subject: RE: Log_mode Date: Mon, 4 Nov 2002 03:02:37 -0700 This is a multipart message in MIME format. --=_alternative 00372BCB87256C67_= Content-Type: text/plain; charset="US-ASCII" Hi Uwe, Thanks for the quick response. I would be grateful if you could help me with the complete syntax for the dbmcli commands to set the log mode to demo, perform the complete data backup in afmin (cold) mode and restart the database. I have the databse server on a node different from the one in which my process is executed and to date I keep getting a user authorization failed message whenever I try to use dbmcli. Thanks again -Mohamed "Hahn, Uwe" <[EMAIL PROTECTED]> 11/04/2002 02:51 AM To "'Mohamed Koker'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] cc Subject RE: Log_mode Normally users want to backup the log for recovery purpose. This is supported by "autosave log" which must be enabled. This keeps the log volume(device) free for working. If for any reason the log and revovery ability does not interest, you can set the database permanently to the log mode DEMO or you can use another variant with "dbmcli -d ... -u ... util_execute set log mode demo" After this you can reenable the "normal" log mode with a complete data backup in admin(cold) mode. regards Uwe > -----Original Message----- > From: Mohamed Koker [mailto:Mohamed.Koker@;mentatsolutions.com] > Sent: Montag, 4. November 2002 10:24 > To: [EMAIL PROTECTED] > Subject: Log_mode > > > I have a process which needs to be run each night and > essentially consists > of deleting a number of tables and then repopulating them > based on an number > of XML files. > > I found that unless I set the log_mode to demo, I end up > filling up my log > device. I sometimes get the same problem if I execute a query > with a lot of > outer joins. > > I would like to be able to change the log mode to demo just > before I execute > this process and then revert to single or dual after this > process executes. > Can I accomplish this via SQL or do I need to use dbmcli and > if so what is > the relevant command I need to use ? > > Is there any other way of preventing the log device from > being filled ? > > Cheers > > -Mohamed > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > --=_alternative 00372BCB87256C67_= Content-Type: text/html; charset="US-ASCII" <br><font size=2 face="sans-serif">Hi Uwe,</font> <br> <br><font size=2 face="sans-serif">Thanks for the quick response.</font> <br> <br><font size=2 face="sans-serif">I would be grateful if you could help me with the complete syntax for the dbmcli commands to set the log mode to demo, perform the complete data backup in afmin (cold) mode and restart the database.</font> <br> <br><font size=2 face="sans-serif">I have the databse server on a node different from the one in which my process is executed and to date I keep getting a user authorization failed message whenever I try to use dbmcli.</font> <br> <br><font size=2 face="sans-serif">Thanks again</font> <br> <br><font size=2 face="sans-serif">-Mohamed</font> <br> <br> <br> <table width=100%> <tr valign=top> <td width=39%><font size=1 face="sans-serif"><b>"Hahn, Uwe" <[EMAIL PROTECTED]></b> </font> <p><font size=1 face="sans-serif">11/04/2002 02:51 AM</font> <td width=60%> <table width=100%> <tr> <td> <div align=right><font size=1 face="sans-serif">To</font></div> <td valign=top><font size=1 face="sans-serif">"'Mohamed Koker'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED]</font> <tr> <td> <div align=right><font size=1 face="sans-serif">cc</font></div> <td valign=top> <tr> <td> <div align=right><font size=1 face="sans-serif">Subject</font></div> <td valign=top><font size=1 face="sans-serif">RE: Log_mode</font></table> <br> <table> <tr valign=top> <td> <td></table> <br></table> <br> <br> <br><font size=2><tt>Normally users want to backup the log for recovery purpose.<br> This is supported by "autosave log" which must be enabled.<br> This keeps the log volume(device) free for working.<br> <br> If for any reason the log and revovery ability does not interest,<br> you can set the database permanently to the log mode DEMO<br> or you can use another variant with<br> "dbmcli -d ... -u ... util_execute set log mode demo"<br> After this you can reenable the "normal" log mode with a complete data backup in admin(cold) mode.<br> <br> regards<br> Uwe<br> <br> > -----Original Message-----<br> > From: Mohamed Koker [mailto:Mohamed.Koker@;mentatsolutions.com]<br> > Sent: Montag, 4. November 2002 10:24<br> > To: [EMAIL PROTECTED]<br> > Subject: Log_mode<br> > <br> > <br> > I have a process which needs to be run each night and <br> > essentially consists<br> > of deleting a number of tables and then repopulating them <br> > based on an number<br> > of XML files.<br> > <br> > I found that unless I set the log_mode to demo, I end up <br> > filling up my log<br> > device. I sometimes get the same problem if I execute a query <br> > with a lot of<br> > outer joins.<br> > <br> > I would like to be able to change the log mode to demo just <br> > before I execute<br> > this process and then revert to single or dual after this <br> > process executes.<br> > Can I accomplish this via SQL or do I need to use dbmcli and <br> > if so what is<br> > the relevant command I need to use ?<br> > <br> > Is there any other way of preventing the log device from <br> > being filled ?<br> > <br> > Cheers<br> > <br> > -Mohamed<br> > <br> > <br> > <br> > <br> > _______________________________________________<br> > sapdb.general mailing list<br> > [EMAIL PROTECTED]<br> > http://listserv.sap.com/mailman/listinfo/sapdb.general<br> > <br> </tt></font> <br> --=_alternative 00372BCB87256C67_=-- --__--__-- Message: 11 From: "Hahn, Uwe" <[EMAIL PROTECTED]> To: "'Mohamed Koker'" <[EMAIL PROTECTED]>, [EMAIL PROTECTED] Subject: RE: Restore instance under Windows Date: Mon, 4 Nov 2002 11:19:00 +0100 This behaviour you describe is not supported, but.. The Data and Log volumes of one online database are not logical compatible to another. You can use the Data backup from A install it on B but do not restart it. You can then "feed" B with log backups from A. But at the moment you restart B to mode online(warm) you have finally created a new instance with its own "life-cycle". This is often used as a kind of standby szenario. If you want to re enable the standby you have to start again with a complete backup from A install a new instance B and restore the log backups from A (without restarting B). regards Uwe > -----Original Message----- > From: Mohamed Koker [mailto:Mohamed.Koker@;mentatsolutions.com] > Sent: Montag, 4. November 2002 11:01 > To: [EMAIL PROTECTED] > Subject: Restore instance under Windows > > > I created a database instance on machine A, added some data, created a > backup for migration, and used this to create a database > instance on machine > B by recovering the backup from machine A. > > So far, so good. > > My problem begins when I update the data on machine A, make a > new backup and > try to bring both machines into sync by restoring the new > backup on machine > B. This always fails at the point when I restart the database. > > The only way I have managed to bring the two databases into sync is by > dropping the instance on machine B and recreating it based on > the backup > from machine A. > > This strikes me as more than a little odd. > > Can someone tell me what I am doing wrong ? Is there a step I > am missing ? > > I am using 7.30.28 under Windows 2000 on both machines and am > using the > DBMGUI. > > Thanks in advance > > -Mohamed > > > > > _______________________________________________ > sapdb.general mailing list > [EMAIL PROTECTED] > http://listserv.sap.com/mailman/listinfo/sapdb.general > --__--__-- _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general End of sapdb.general Digest _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
