Search this list for the email titled:
"7.3 to 7.5 [NON-PARALLEL] Migration Explained (HOWTO)"
I have done this migration on a SuSE Linux x86 to x64 platform. If you have
questions then shoot me a email but the email should be all you need.
-Original Message-
From: Ritter, Robert [mailto
The link below states that this module runs on X86_32 but no mention about
x64? Doesn't it run on a x64 web server that accesses a MaxDB installation
installed on a x64 server?
http://dev.mysql.com/doc/maxdb/en/41/6b999394093e23e1000a114cbd/frameset
.htm
I have also heard many comments about
Found in the Database Manager Protocol log.
2006-02-21 11:34:28 0x5c50 ERR -24988 DBM ERR_SQL: sql error
0x5c50 ERR -24988 DBM 100,Row not found
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http:
I have laid out the scenario below. Essentially my question is why does a FK
delete restriction prevent my update trigger from working? ... I'm not
deleting I am updating.
*
[Child table has foreign key defined as:]
FORE
same here ... have ntpd on the db server and changing/starting/stopping/etc.
has no ill effects that we have noticed.
-Original Message-
From: Simon Matter [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 04, 2006 01:27
To: Joe Haynes
Cc: MaxDB Mailinglist
Subject: Re: Managing Time on M
finally found an old mailing list post with this in it:
getconf GNU_LIBPTHREAD_VERSION
SuSE 9.1 (32-bit) returns NPTL 0.61
SuSE 9.2 (amd64) returns NPTL 2.3.3
Would that imply that all 9.x suse installations are good to go or just the
9.2x64 strain?
-Original Message-
From: Kevin
I can't find any info on how to issue a command to see if a current system
has ntpl support already built in ... does anyone know where to find some?
-Original Message-
From: Sven Köhler [mailto:[EMAIL PROTECTED]
Sent: Thursday, December 29, 2005 11:57
To: maxdb@lists.mysql.com
Subject:
back in business.
-Original Message-
From: "Döhr, Markus ICC-H" [mailto:[EMAIL PROTECTED]
Sent: Friday, December 16, 2005 14:49
To: Kevin Wilson
Subject: RE: backup of installation and data directories
> What do you mean by logical backup? My full backup is done in
> onl
r 16, 2005 14:05
To: Kevin Wilson
Cc: Maxdb (E-mail)
Subject: RE: backup of installation and data directories
> I have a full backup exported out every night. So if a drive
> were to fail and I have to restore from tape then would
> restoring sata1 and whatever it copied of sata2 an
lto:[EMAIL PROTECTED]
Sent: Friday, December 16, 2005 13:42
To: Kevin Wilson
Cc: Maxdb (E-mail)
Subject: RE: backup of installation and data directories
> Install locations specified during setup are:
>
> iprogram = /sata1
> idata= /sata2
> backups = /hdc1 (autologs)
>/
PROTECTED]
Sent: Friday, December 16, 2005 13:15
To: Kevin Wilson; Maxdb (E-mail)
Subject: RE: backup of installation and data directories
If you wanna be sure shutdown the database and backup then.
> Seeing how the data directories are changing but I wonder if
> I could exclude the pat
Seeing how the data directories are changing but I wonder if I could exclude
the path but backup the rest and it be ok?
-Original Message-
From: Kevin Wilson
Sent: Friday, December 16, 2005 13:02
To: Maxdb (E-mail)
Subject: RE: backup of installation and data directories
ok, sys down
PROTECTED]
Sent: Friday, December 16, 2005 13:03
To: Kevin Wilson
Cc: Maxdb (E-mail)
Subject: RE: backup of installation and data directories
Kevin,
This is not really a good idea with a database that is
currently running. The backup software will only be able
to capture each file a few chunks at a time
, December 16, 2005 12:41
To: Kevin Wilson; Maxdb (E-mail)
Subject: RE: backup of installation and data directories
> I want to have our tape backup system come in and copy to
> tape the full directory tree(s) of where maxdb is installed
> while the database is running in online
I want to have our tape backup system come in and copy to tape the full
directory tree(s) of where maxdb is installed while the database is running
in online mode. Is there any reason I cannot do this?
Thanks
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To un
Is there any way I can activate these new values without taking the db
offline?
maxdb v7.5.0.23-x64
-Original Message-
From: Kevin Wilson
Sent: Thursday, December 15, 2005 09:47
To: Maxdb (E-mail)
Subject: RE: (2) How is exactly is this query too complicated?
I increased workdata and
I increased workdata and workstack support parms to their maximums ...
should that do the trick?
-Original Message-
From: Kevin Wilson
Sent: Thursday, December 15, 2005 09:44
To: Maxdb (E-mail)
Subject: (2) How is exactly is this query too complicated?
Found Holgers email about the
Found Holgers email about the workdatasize, I'll give that a try and see
what happens.
any other parms like this that we should increase while I am in there to
prevent taking db offline again?
-Original Message-
From: Kevin Wilson
Sent: Thursday, December 15, 2005 09:35
To: Max
SELECT RMA.RMA_ID,RMA.SUMMARY,RMA.NOTE FROM RMA WHERE (UPPER(RMA.NOTE) like
'%RUSTIC%' or UPPER(RMA.NOTE) like '%DRAM%' or UPPER(RMA.NOTE) like '%RAM%')
3 OR statements on a varchar(5000) field should not cause this error, is
there a workaround I can use to fetch my report?
thanks
--
MaxDB Disc
Sorry for the bad report folks, I'm getting old and senile.
-Original Message-
From: Schroeder, Alexander [mailto:[EMAIL PROTECTED]
Sent: Tuesday, November 22, 2005 6:56 AM
To: Kevin Wilson; Hermann Mundprecht; Sven Köhler
Cc: maxdb@lists.mysql.com
Subject: RE: DBM GUI for Linux
I am fairly certain I read that the DBM GUI for 7.6 series is developed
using xWidgets which is cross-platform so you will be able to run the same
gui in KDE/Gnome/Windows.
-Original Message-
From: Hermann Mundprecht [mailto:[EMAIL PROTECTED]
Sent: Monday, November 21, 2005 1:20 PM
To: Sve
search the list for subject "7.3 to 7.5 [NON-PARALLEL] Migration Explained
(HOWTO)" and ignore the 7.3 steps and instead start off with a complete
backup and then on the new system to a recovery with initialization.
-Original Message-
From: Beermann, Albert [mailto:[EMAIL PROTECTED]
Sent:
Why can't I use a select to set a procedure variable? It barks out this
error where it hit the line "SET B = SELECT ..."
CREATE DBPROC CLEANSNFLAGSDUPES(IN PREFIX VARCHAR(4), IN MESSAGE
VARCHAR(1000)) AS
VAR FID INTEGER; B VARCHAR(6); NROWS INTEGER;
SET FID = 0;
SET NROWS = 0;
DECLARE C1 CURSOR FO
Never mind, I thinks me found the problem with this old hacked up dbproc.
thanks anyway.
-Original Message-
From: Kevin Wilson
Sent: Friday, October 07, 2005 11:36 AM
To: Maxdb (E-mail)
Subject: Problem using TIME datatype in dbproc
Importance: High
Why does this return "Inte
Why does this return "Integrity constraint violation;-8006 POS(1) Data types
must be compatible"? The field in rectbl is a TIME datatype.
CREATE DBPROC SP_UPDATE_TIME(
IN REC_ID FIXED (10,0),
IN UPDTIME TIME
)
AS UPDATE MYDB.RECTBL SET UPDTIME = :UPDTIME WHERE REC_ID = :REC_ID;
to be the
same? I am running 7.5.0.23 on our production instance but would like to
know if I can have the standby instance use 7.5.0.30 or even 7.6?
-Original Message-
From: Kevin Wilson
Sent: Friday, October 07, 2005 9:39 AM
To: Maxdb (E-mail)
Subject: FW: OS question concerning Failo
Sorry but I meant inquire for both a regular standby server and a hot
standby (clustered solution).
-Original Message-
From: Kevin Wilson
Sent: Friday, October 07, 2005 9:29 AM
To: Maxdb (E-mail)
Subject: OS question concerning Failover setup
I have maxdb running on SuSE 9.2 64bit w
I have maxdb running on SuSE 9.2 64bit w/ AMD Opteron hardware and I want to
setup my other duplicate server using 9.3 64bit ... can I do this and still
use the 9.3 server as the hot standby server?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:
From: Schroeder, Alexander [mailto:[EMAIL PROTECTED]
Sent: Friday, September 30, 2005 2:55 AM
To: Kevin Wilson; Maxdb (E-mail)
Subject: RE: jdbc connections not dying off
Hello Kevin,
'reconnect' does what you think - connections are silently re-connected if
it is
possible (i.e. o
[System Info]
App server:
SuSE 9.1-x32 SMP (AMD)
JSDK 1.4.2_08
Tomcat 5.0.27
DB server:
SuSE 9.2-x64 SMP (AMD)
MaxDB 7.5.0.23
JDBC Driver:
sapdbc-7_5_01_00.jar
I named it this to let me know which version of the db server I downloaded
the
nah, no sql changes needed.
-Original Message-
From: Manuel Reiter [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 13, 2005 11:08 AM
To: Kevin Wilson
Cc: Maxdb (E-mail)
Subject: Re: SAPDB 7.3 -> MAXDB 7.5/7.6 Upgrade / specialists wanted
Hi Kevin,
thanx for the howto,
did you a
I have done the upgrade from 7.3 to 7.5 here at work, I suggest waiting on
7.6 if you are upgrading a production db server. I wrote and sent a
migration howto to the mailing list some time ago, it's attached for you to
reference. If that doesn't get you there then shoot me a question and I'll
do my
search this list for my email about migrations (subject = 7.3 to 7.5
[NON-PARALLEL] Migration Explained (HOWTO)). It outlines the steps to do
what you want. You won't need the first part just the second since you are
already in a version >= 7.5
-Original Message-
From: Brunzema, Martin [ma
-24988,ERR_SQL: sql error
-24300,SQL error (100): Row not found
maxdb v7.5.0.23
dbmgui v7.5.0.18
After doing a select with order by on the default serial primary key column
the results only sort in ascending order when I specify descending. I
attempted to rebuild the serial index for the table
Actually I have imported a Dual AMD Opteron DB instance onto a single proc
AMD Athlon machine without a problem, just have to do a restore with
initialization so you can adjust the db parms.
-Original Message-
From: Heinrich, Tilo [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 27, 2005 8:
I have looked in the general, extended and support lists but I cannot find
this parameter ... am I supposed to be able to see it in the dbmgui?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
1) Full support of ANSI SQL 99 (CASE, all JOIN types, ..)
2) Support of Views and Views on Views
3) Support of User Defined Functions
(preferably via SQLJ - Java running in the database)
4) Inline Views (e.g. SELECT ... FROM (SELECT xx FROM yy) ..)
5) JDBC 3.0 Support (especially RowSet)
-
Will MaxDB running in Oracle mode be compatible with applications, etc. that
use the Oracle db as their backend? Especially those like ERP software that
use stored procedures heavily?
Thanks
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http:
be sure to clear the log AND load the systab after you finish the restore...
1) db_execute clear log
2) load_systab -u , -ud
-Original Message-
From: K Cardal [mailto:[EMAIL PROTECTED]
Sent: Thursday, July 14, 2005 5:31 PM
To: maxdb@lists.mysql.com
Subject: Cannot Connect To DB after rec
MaxDB 7.5.0.23 on Linux
Scenario:
I have a update dbproc that execs multiple update statements in a SUBTRANS
block and has 4 parameters 3 IN and 1 OUT.
after each update I set an internally defined VAR N INT using the following:
SET N = N + $COUNT;
After the last update statement and right bef
Has anyone running Linux (SuSE 9.2 or better in particular) and MaxDB
7.5.0.23 (or better) implemented a hot-standby server? If so, what software
did you use?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTE
You will be best off doing a clean installation of the 64-bit version of
maxdb then doing a import. The complete backup pops in quite nicely between
platforms.
-Original Message-
From: Ken Snider [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 22, 2005 9:45 AM
To: maxdb@lists.mysql.com
Sub
Here ya go.
CREATE DBPROC REASSIGN_PENDING(IN SUSER VARCHAR(10)) AS
VAR callid INTEGER;
SET callid = 0;
DECLARE c1 CURSOR FOR select a.call_id from idb.call a inner join
idb.company b on a.company_id = b.company_id where (a.assign_to = 'jpl' and
a.status = 'PENDING' and (b.territory_code = '520' o
Use a prepared statement and the update will work nicely.
-Original Message-
From: MaxDB SAP [mailto:[EMAIL PROTECTED]
Sent: Wednesday, April 20, 2005 11:44 AM
To: maxdb@lists.mysql.com
Subject: LONG DATA TYPE
Hi List,
I have a table with a field name as Notes and data type as LONG VARC
The online docs state that the Perl DBD is to blame for this message. I
noticed this line in my xserver.prt file ... what is it and why is it
showing up?
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Netstat shows there are over 200 vserver connections established but
sessions reported in the dbmgui shows only a few. Everything is operating
well, users can connect and work but the number of connections keeps
increasing slowly but the number of sessions reported are always from 2 to
10.
maxconn
[app server]
Sun JVM 1.4.2_08
Tomcat 5.0.27
SuSE Linux 9.1-32bit
[db server]
MaxDB 7.5.0.23
SuSE Linux 9.2-64bit
After updating the app server's jvm from 1.4.2_04 to 1.4.2_08 I am noticing
that the jdbc connections from tomcat to the database are stacking up. there
was normally only around 10-20
I think 7.6 has search abilities but what problem do you experience when
using dbprocs? I have dbprocs that fetch rows that contain lvchar columns.
-Original Message-
From: Uwe Haussmann [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 3:27 AM
To: maxdb@lists.mysql.com
Subject: Lon
I am using views and haven't experienced any ill returns. What is the
problem? The WebPTS link comes up with an error.
-Original Message-
From: Becker, Holger [mailto:[EMAIL PROTECTED]
Sent: Thursday, April 14, 2005 3:34 AM
To: Alexey Gaidukov; maxdb@lists.mysql.com
Subject: RE: Impossible
The biggest problem I have is with the jdbc driver and how it (doesn't)
handle implied date format conversions. For instance, if you use the Now()
function in VB it spits out a timestamp value in the format of "MM/DD/
HH:MM AM/PM" and when assigned to a timestamp field the ODBC driver handles
t
You are better off just changing your format to meet their's. I have
struggled long and hard with their dates functionality (or lack thereof) and
it isn't worth your time.
-Original Message-
From: Andreas Goldstein [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 31, 2005 4:45 PM
To: maxdb@
version 7.5.0.23:64bit:ascii on linux64 (opteron).
I have 11980 bytes in varchar plus 3 integer output columns in my join
query, I think this is very small considering the data we have to store and
fetch these days. Error occurs using both the jdbc driver in our reporting
package and in sql_studio
After ever one of these statements:
0 DBM command db_execute SELECT ID,CREATEDATE,USEDSIZE
I see these immediately afterwards:
ERR -24988 DBM ERR_SQL: sql error
ERR -24988 DBM 100,Row not found
Is this a problem? If not, then why even log them?
What would be the harm in setting this to Yes? Would this allow server
functions to finish faster (log writes, cleanup, gb_collection, etc?)
be placed in each webapp's web-inf/lib folder so it instantiates its own
copy of the jdbc driver? Right now I have a single copy in the common/lib
but I experience lags and temp space growth that runs amuck essentially
causing DoS.
Been having the problem where the db runs good for a while then I
Log writes and waits only differ by 1. Db is running on a RAID-5 system so
storing the log on another disk is not an option.
The log_io_queue has 0 overflows. Any tips on how to get the waits for a
log-writer down?
when you change maxusertasks or other transaction related parameters. It is
set to 3 when the formula states maxusertasks+1+1. My maxusertasks is set to
100. Can I edit this directly in the support_config_params file (if one
exists)?
Will setting this to yes help anything if I use multiple users to emulate a
multiple database scheme in a single instance?
I too experience that problem. Any query hitting the same tables at the same
time will cause a performance lag, sometimes very significant lag. For
instance, if 1 user sends a vague search query that will return a
significant listing that query will block out another user that sends a
prikey search
OH THANK GOD !
"Functions LENGTH and SUBSTR for LOBs"
-Original Message-
From: Montag, Marina [mailto:[EMAIL PROTECTED]
Sent: Friday, February 11, 2005 9:00 AM
To: [EMAIL PROTECTED]; maxdb@lists.mysql.com
Subject: Updated: New version 7.6 (beta) of MaxDB software available now
Hell
[v7.5.00.23 on 64-bit Linux]
I have 2 data and 2 (mirrored) log volumes (created at install time) and
then the autolog activated. I had to add 2 more data volumes on the fly to
deal with the temp space saturation problem while I was running a data
import but I cannot add their corresponding log vo
According to the change log for 7.5.0.23 you fixed the problem (quoted
below) where unclosed cursors chew up temp space...well it still happens
with apps even when using the latest jdbc driver.
I also have a bug for "db_adddevice LOG" but I will submit that in another
email.
Guess I should have stated besides SAP R/3.
But I would also like to know why the SAP All-in-One and SAP Business
packages don't list MaxDB as a backend option?
-Original Message-
From: Michael Bielicki [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 20, 2005 2:56 PM
To: Kevin W
Most ERP packages I find only support ms-sql, oracle, db2, sybase, etc. Are
there any that allow MaxDB as its backend?
Thanks much.
can we get that will allow us to use MaxDB?
For those of you still running a 7.3 instance with plans to migrate to 7.5
this FYI may be of interest.
There exists a bug in 7.3[.0.34] that for varchar(n) indexed fields a
redefinition of the field length does not get pushed out to its index. When
you migrate your instance to 7.5, the index with
I have found that 'character 251' and the like of the ascii code set are the
cause of the problem. These are causing the jdbc driver on linux to stop
processing the translation of the character data into a string.
-Original Message-----
From: Kevin Wilson
Sent: Monday, January 10,
tudio:
Kevin -
I can extend a lower
-Original Message-
From: Kevin Wilson
Sent: Monday, January 10, 2005 10:25 AM
To: Maxdb (E-mail)
Subject: JDBC StreamTranslator issue
line 261 of StreamTranslator.java (StreamTranslator.getString()) errors when
reading a ascii_long column of data whe
line 261 of StreamTranslator.java (StreamTranslator.getString()) errors when
reading a ascii_long column of data when the driver is ran in tomcat 5.0.27
on linux. the same jdbc driver ran in the netbeans 3.6 integrated tomcat
5.0.19 for the same project on win2k does not emit the error. Both are
op
Must I set the migrated 7.3 instance to use Unicode (dbparm="YES") at
instance creation time? Could this be why I am getting the -3007 DDL DML
error message.
This question is related to earlier email subject:
The cause of -> "-3007 POS(1) Invalid sequence of DML and DDL statements"
The login user's password during create instance in dbmgui has to have a
password that was created with DES encryption. If you created this maxdb
owner user when using MD5 or Blowfish then you get an error when dbmgui
tries to logon.
Ahh, that is where the little buggers are hiding - thanks mucho!
Oddly enough, this location is not listed (nor spoke of) anywhere in the
online documentation. Plus grep'ing "/usr/*" takes so frickin long that you
cancel the search before it has a chance to find it.
-Original Message-
F
After installing a .19 server and then removing (what I thought to be) all
files installed a rerun shows previous settings for the dependent, program
and data paths are automatically pulled in. I found a file (sdb) in
/etc/opt/ that did have these values set so I whacked it but a rerun on
SDBINST s
For old sql queries in version 7.3 like:
select a.*,b.*,c.*,d.* from a,b,c,d where
a.id1 = b.id1 and a.id2 = c.id2 <...> on so on.
if you alter this same query to use JOIN syntax instead of the equals
conditions then the query runs in 7.5.0.18 &.19. If you add the old style
join syntax (+) then
I figured I would share with those that are still running a 7.3.0.3x
instance a easy method (kind of) to transfer that instance to the latest and
greatest MaxDB running on another server without the need of having to have
a parallel installation and using the DBMGUI interface.
[Execute steps 1 - 8
Performance of "upper(company_name) LIKE '%XXX%'" when used in a where
clause is terrible. Thinking the case sensitivity was to blame I created
(and indexed) another column that mirrors the company names column but in
uppercase text. The explain output shows no improvement for
"upr_company_name LIK
our app is server based so all connections are from the same host.
every so often someone runs a mongo query that just bogs everything down to
a point where nobody can fetch any data from the database.
the kill session list page (in dbmgui) does not show which tasks are
blocking others so I have
The following index hangs sql studio when executed in both internal and
Oracle modes. According to the doc (
http://dev.mysql.com/doc/maxdb/en/6d/117c4dd14811d2a97400a0c9449261/content.
htm ) I should be able to do this if I am reading it correctly.
CREATE INDEX "IDX_PERSON_UFNAME" ON "MYDB"."PER
7:34 AM
To: Kevin Wilson
Subject: FW: ending a database session
-Original Message-
From: Dittmar, Daniel [mailto:[EMAIL PROTECTED]
Sent: Wednesday, October 06, 2004 10:24 AM
To: 'PcgScrapAddy'
Subject: RE: ending a database session
>how about finding out which task
Would you say that the Opteron release is "mission-critical" ready?
-Original Message-
From: Montag, Marina [mailto:[EMAIL PROTECTED]
Sent: Friday, September 24, 2004 2:20 AM
To: '[EMAIL PROTECTED]'; '[EMAIL PROTECTED]'
Subject: Version 7.5.00.18 of MaxDB software vailable now
Hello,
What kind of state would a servlet app using the sapdb jdbc driver have to
be in to cause this type of log entry? Also, I have no apps running locally
on the db server so is the local connection shown from a servertask thread?
2004-08-31 19:34:52 16217 11007 COMMUNIC wait for connection T41
2
maxdb table into ms sql server using dts so I can do a text search of that
field.
Error = cannot instantiate storage object for source column <...> (Blob
object)
any ideas?
I just noticed this parm and wondered if switching it to NO would cause any
problems since my instance is not for live-cache or r/3?
Why in the world would you want to do this? Think about it, you have similar
data in two different columns that should be in one. If a value in (c) is
the same as (b) which enables it to have a FK link to (a) then why not merge
the columns and save yourself some headaches?
-Original Message---
How exactly does maxdb allow me specify the old files when creating the new
instance after install? I have only seen new instance new instance for
recovery. The first will overwrite any existing files of the same name and
the second requires a backup medium not just the old data files that are
ther
In the event of a system disk failure, whereby you have your data files (log
and/or data) on a different disk, is it possible to simply install maxdb
again and point the data paths to the existing files and the server come
back up?
If it is not how I describe how would you go about specifying exis
You are kidding right???
(RTFM my friend)
http://www.sapdb.org/7.4/htmhelp/default.htm
Don't mean to be insensitive but these guys have better things to do than
teach a DBA 100 course. You can also use the DBMGUI where it is all
point-n-click.
-Original Message-
From: [EMAIL PROTECTED] [
1) Can MaxDB 32-Bit be successfully installed and ran on a Opteron system?
2) Is there any concrete plans as to when a x86_64 port could be expected?
Yes,
Using the DBMGUI 1st edition do a migration backup. Then on the 7.4 machine
create a new instance for restore using DBGUI second edition or later and
specify the migration backup when prompted.
-Original Message-
From: Andrea Setti [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 23,
You would be correct. If you have a sweet system that can handle the
additional load of duplicated resource allocations then have at it. I had to
go for the opposite.
-Original Message-
From: Filip Sergeys [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 9:18 AM
To: Kevin Wilson
Cc
You are better off using different USERS to house the db objects in a single
instance. This will allow you to use less resources to accomplish the same
effect.
-Original Message-
From: Filip Sergeys [mailto:[EMAIL PROTECTED]
Sent: Friday, June 18, 2004 7:57 AM
To: [EMAIL PROTECTED]
Subject
how can I detect and kill a (individual) connection that is tying up the
database for other users.
Anything to do with joins/orders (especially tables with large text fields)
are calculated incorrectly by the query optimizer. I have already submitted
a dataset and schema to allow them to test on a real world situation so
hopefully this will yield positive results.
follow my emails with subject
opps...wrong list.
-Original Message-
From: Kevin Wilson
Sent: Monday, June 14, 2004 1:41 PM
To: [EMAIL PROTECTED]
Subject: PostgreSQL Stories
Please share any stories (good and bad) you may have about running JIRA with
PostgreSQL as its backend datastore.
Thanks,
Kevin
Please share any stories (good and bad) you may have about running JIRA with
PostgreSQL as its backend datastore.
Thanks,
Kevin
-
From: John Singleton [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 4:26 PM
To: Kevin Wilson
Cc: [EMAIL PROTECTED]
Subject: Re: UPDATE FROM STATEMENT NOT SUPPORTED
Kevin,
After looking at what that statment does in MS SQL Server, I think this
is the syntax you are looking for:
UPDATE
It allows you to update using a joined table's column as the source
information for the target column you want to update.
-Original Message-
From: John Singleton [mailto:[EMAIL PROTECTED]
Sent: Friday, June 11, 2004 4:17 PM
To: Kevin Wilson
Cc: [EMAIL PROTECTED]
Subject: Re: UPDATE
Unable to do mass update from a table using:
UPDATE SET = 'X' FROM , WHERE
Get "Invalid end of SQL statement." on the FROM keyword. This is a real
handy item to have (use it in MS SQL Server). It may be a non-standard T-SQL
extension but I am not sure. Nonetheless, I would think that adding
This simple join query brings maxdb 7.5.0.14 to its knees where this same
*exact* query using the same data in PostgreSQL only takes 6 seconds to
fetch and 24 seconds to display. MaxDB (SQL Studio) however locks up and
never finishes. Below is some EXPLAIN output for queries I used to see what
was
After using SDBINST to upgrade my 7.3.0.46 server and its instances
(production and a test one (the test one isn't ever used)) I can enter Admin
mode but any attempt to enter online causes shutdown. Also other select
operations in Admin mode causes a shutdown to occur as well. Below is a
snippet of
1 - 100 of 150 matches
Mail list logo
