Discussion about MaxDB (formerly SAP DB)

Keith | 1 Apr 2006 01:19

RE: Horrible Query Performance on Update

Tablename	Column_or_Index	Strategy
PageCount
T          				table scan
42
D		deviceinfo_idx	join via indexed column
379618
					  No temporary results created
					  Result is copied, costvalue is
862630

-----Original Message-----
From: Kakhandiki, Ashwath [mailto:ashwath.kakhandiki <at> sap.com] 
Sent: Friday, March 31, 2006 4:47 PM
To: Keith Arnold; maxdb <at> lists.mysql.com
Subject: RE: Horrible Query Performance on Update

Hi Keith,
What is the result of this explain statement?

Explain
SELECT T.SUBLOTNO FROM TMPTBL T, DEVICEINFO D
		    WHERE T.REPORT_ID = D.REPORT_ID

I think it might help if you create an index on TMPTBL (report_id,
sublotno).

Thanks,
Ashwath Kakhandiki
MAXDB Dev. Support
SAP Labs LLC, Palo Alto

(Continue reading)

Kakhandiki, Ashwath | 1 Apr 2006 01:53

Picon

RE: Horrible Query Performance on Update

You can see it is doing a table scan on TMPTBL. So please create an
index on TMPTBL (on columns report_id, sublotno) and run the explain
again. Check if the final costvalue goes down from 862630.

-----Original Message-----
From: Keith [mailto:keith <at> theboxergroup.com] 
Sent: Friday, Mar 31, 2006 15:20 PM
To: Kakhandiki, Ashwath; 'Keith Arnold'; maxdb <at> lists.mysql.com
Subject: RE: Horrible Query Performance on Update

Tablename	Column_or_Index	Strategy
PageCount
T          				table scan 42
D		deviceinfo_idx	join via indexed column 379618
		No temporary results created
		Result is copied, costvalue is 862630

-----Original Message-----
From: Kakhandiki, Ashwath [mailto:ashwath.kakhandiki <at> sap.com]
Sent: Friday, March 31, 2006 4:47 PM
To: Keith Arnold; maxdb <at> lists.mysql.com
Subject: RE: Horrible Query Performance on Update

Hi Keith,
What is the result of this explain statement?

Explain
SELECT T.SUBLOTNO FROM TMPTBL T, DEVICEINFO D
		    WHERE T.REPORT_ID = D.REPORT_ID

(Continue reading)

Keith Arnold | 1 Apr 2006 01:58

RE: Horrible Query Performance on Update

I created an index on TMPTBL(record_id) and reran the EXPLAIN:

TBL	COLUM/INDEX		STRATEGY			PAGECNT
D	deviceinfo_idx	index scan			 379618
				Only index accessed
T	tmpidx		join via indexed column	 1
				Result copied, costvalue 346439

Still the update takes forever.

Keith
-----Original Message-----
From: Keith [mailto:keith <at> theboxergroup.com] 
Sent: Friday, March 31, 2006 5:20 PM
To: 'Kakhandiki, Ashwath'; 'Keith Arnold'; 'maxdb <at> lists.mysql.com'
Subject: RE: Horrible Query Performance on Update

TBL	COLUM/INDEX		STRATEGY			PAGECNT
T  				table scan			42
D	deviceinfo_idx	join via indexed column	379618
				No temp results created
				Result copied, costvalue 862630

-----Original Message-----
From: Kakhandiki, Ashwath [mailto:ashwath.kakhandiki <at> sap.com] 
Sent: Friday, March 31, 2006 4:47 PM
To: Keith Arnold; maxdb <at> lists.mysql.com
Subject: RE: Horrible Query Performance on Update

Hi Keith,

(Continue reading)

Alexei Novakov | 1 Apr 2006 02:25

Re: Horrible Query Performance on Update

Try to update statistics:

update statistics TMPTBL estimate sample 100 percent

Alexei Novakov

Keith Arnold wrote:
> I created an index on TMPTBL(record_id) and reran the EXPLAIN:
>
> TBL	COLUM/INDEX		STRATEGY			PAGECNT
> D	deviceinfo_idx	index scan			 379618
> 				Only index accessed
> T	tmpidx		join via indexed column	 1
> 				Result copied, costvalue 346439
>
> Still the update takes forever.
>
> Keith
> -----Original Message-----
> From: Keith [mailto:keith <at> theboxergroup.com] 
> Sent: Friday, March 31, 2006 5:20 PM
> To: 'Kakhandiki, Ashwath'; 'Keith Arnold'; 'maxdb <at> lists.mysql.com'
> Subject: RE: Horrible Query Performance on Update
>
> TBL	COLUM/INDEX		STRATEGY			PAGECNT
> T  				table scan			42
> D	deviceinfo_idx	join via indexed column	379618
> 				No temp results created
> 				Result copied, costvalue 862630
>

(Continue reading)

Zabach, Elke | 3 Apr 2006 10:05

Picon

AW: Horrible Query Performance on Update

Keith Arnold wrote:
> 
> Friendly and Helpful List Members,
> 
> We are running MaxDB 7.5.00.24 on an X86 machine w/ 2x3Ghz CPU, 2G
ram,
> SCSI
> Mirrored drives, Win2K3 Std.  Data cache and catalog hit rates are
above
> 99.9%.
> 
> I have 2 tables:
> 
> DEVICEINFO (report_id int, groupnum int) approx 27,000,000 records
> (2.8GB),
> no keys but an index on report_id
> There are approx 1000 records per unique report_id.
> 
> TMPTBL (report_id int, sublotno int) approx 200 records, no keys, no
index
> 
> When I run the SQL
> 
> UPDATE DEVICEINFO D
> SET GROUPNUM = (SELECT SUBLOTNO FROM TMPTBL T
> 		    WHERE T.REPORT_ID = D.REPORT_ID)
> 
> The data base drops to it's knees and eventually times out.  I tried
> adding
> WHERE REPORT_ID IN (SELECT REPORT_ID FROM TMPTBL)

(Continue reading)

John Brown | 3 Apr 2006 13:48

Picon

"System error: AK Catalog information not found" when executing a DELETE statement

Hi all,

I am getting 'System error: AK Catalog information not found' when executing a simple DELETE FROM 
MYTABLE WHERE ID=1 query on one of my tables.

The knldiag says that 
2006-04-03 15:36:12    24 ERR 51105 AK CACHE 0000000000000000006900010000000000000000
2006-04-03 15:36:12    24 ERR 51080 SYSERROR -9205 AK Catalog information not found:0

I recently moved from MaxDB 7.5.00.8 to MaxDB 7.6.00.16. I created full backup for migration, and restored 
it on another server running MaxDB 7.6.00.16. I used 'Recovery with initialization' from DBMGUI. I then 
upgraded system tables, and executed 'Check Database Structure' to make sure everything is all-right.
The 
check did not return any errors. It seems that the migration was not so successfull after all?

I would appreciate any comments or ideas on what to do next.

Best regards,
John Brown

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org

Joerg.Wenzel | 4 Apr 2006 13:12

filldb.py

Hello,

have anybody the script filldb.py from SAP ADM515?

Thanks,

Jörg Wenzel

Dittmar, Daniel | 5 Apr 2006 11:55

Picon

RE: filldb.py


>have anybody the script filldb.py from SAP ADM515?

There is a recent version at
ftp://ftp.sap.com/pub/maxdb/tmp/filldb.py

Call as
<dependent_path>/bin/x_python filldb.py -h
for help

Daniel Dittmar

-- 
Daniel Dittmar
SAP Labs Berlin
daniel.dittmar <at> sap.com  

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org

Manuel Reiter | 6 Apr 2006 14:05

SAPDB 7.3.00.24 64 Bit for Solaris / Download wanted

Has anybody the SAPDB in the version 7.3.00.24 64 Bit for Solaris for 
download ?
regards Manuel

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org

Dittmar, Daniel | 6 Apr 2006 14:13

Picon

RE: SAPDB 7.3.00.24 64 Bit for Solaris / Download wanted


>Has anybody the SAPDB in the version 7.3.00.24 64 Bit for Solaris for 
>download ?

Why does it have to be 7.3.00.24? Release 7.3.00.48 is still available
at ftp://ftp.sap.com/pub/sapdb/bin/sun/.

Daniel Dittmar

-- 
Daniel Dittmar
SAP Labs Berlin
daniel.dittmar <at> sap.com  

--

-- 
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe:    http://lists.mysql.com/maxdb?unsub=gcdm-maxdb <at> m.gmane.org

Group

gmane.comp.db.maxdb.

Project Web Page

Discussion about MaxDB (formerly SAP DB)

Search Archive

Page

1 | 2 | 3 | 4 | 5 | 6 | 7

Articles in period: 66

April 2006

Language

Change language

Options

Current view: Threads only / Showing only 20 lines / Not hiding cited text.
Change to All messages, whole messages, or hide cited text.

Post a message
NNTP Newsgroup
Classic Gmane web interface
XML

XML

RSS Feed
List Information

About Gmane

Recent entries

This mailing list is closed. (8 Oct 2007)
import csv (5 Oct 2007)
MaxDB sales and support reverting from MySQL AB to SAP AG (4 Oct 2007)
maxdb stored procedure maximum size question (2 Oct 2007)
delete takes too much time. (2 Oct 2007)
catalog error (2 Oct 2007)
JDBC Connection's setAutocommit() should call implicit commit() (2 Oct 2007)
maxdb 7.6.00.37 (28 Sep 2007)
".. WHERE id IN (..1340 ids..)" => error (28 Sep 2007)
Initialization of variables in functions (24 Sep 2007)
Number of MaxDB users (19 Sep 2007)
MaxDB error (18 Sep 2007)
Title should have been: Situation changes for MySQL and MaxDB ( and (18 Sep 2007)
MySQL / MaxDB - Transition of (18 Sep 2007)
AW: [LIKELY JUNK]query about database check structure (14 Sep 2007)
query about database check structure (13 Sep 2007)
Is MySQL separating from MaxDB? (10 Sep 2007)
Backup history cleaning (6 Sep 2007)
LOADERCLI - sequence of parameters, bug (30 Aug 2007)
User in wait state (29 Aug 2007)
Keep "temporary" tables after BW query execution (27 Aug 2007)

Archives

11	October 2007
30	September 2007
56	August 2007
62	July 2007
78	June 2007
69	May 2007
101	April 2007
89	March 2007
61	February 2007
107	January 2007
49	December 2006
99	November 2006
69	October 2006
116	September 2006
75	August 2006
101	July 2006
109	June 2006
144	May 2006
65	April 2006
174	March 2006
132	February 2006
176	January 2006
151	December 2005
142	November 2005
164	October 2005
231	September 2005
237	August 2005
203	July 2005
255	June 2005
165	May 2005
275	April 2005
260	March 2005
308	February 2005
302	January 2005
261	December 2004
283	November 2004
206	October 2004
274	September 2004
241	August 2004
353	July 2004
576	June 2004
402	May 2004
367	April 2004
434	March 2004
575	February 2004
415	January 2004
476	December 2003
419	November 2003
477	October 2003
149	September 2003
3	August 2003

Design

Zawodny | Right Menu | Left Menu

Your Own Design

Paste the URL of your CSS below. Download CSS template