Parallel ASO Load - Multiple Buffers

Parallel ASO Load - Multiple Buffers

DanP
DanP

February 20th, 2013, 6:57 pm #1

I am using the syntax as I see it in the DBAG and still getting an error:


IMPORT DATABASE $(APPname).$(DBname) DATA FROM LOAD_BUFFER WITH BUFFER_ID 901,902,903,904,905 ;


in MaxL I get this error:

MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905 ;

essmsh error: Parse error near ,902,903,904,905


I have tried '901,902,903,904,905'

I have tried "901,902,903,904,905"

and putting spaces after the commas. Any ideas???



From the techref:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Commits the contents of multiple data load buffers (buffer_id 1 and buffer_id 2) to the AsoSamp.Sample database.


From the DBAG:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Commits the contents of multiple data load buffers (buffer_id 1 and buffer_id 2) to the AsoSamp.Sample database.
Quote
Share

Dean Haraguchi
Dean Haraguchi

February 20th, 2013, 7:09 pm #2

Try moving your ending semicolon to be immediately after the ending buffer number.
Quote
Share

DanP
DanP

February 20th, 2013, 7:19 pm #3

and it did not work:


MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905;

essmsh error: Parse error near ,902,903,904,905;

essmsh timestamp: Wed Feb 20 14:17:48 2013
Quote
Share

TimG
TimG

February 20th, 2013, 7:27 pm #4

Have you tried it without the positional parameters - i.e. with the appname and dbname hard-coded?
Quote
Share

DanP
DanP

February 20th, 2013, 7:33 pm #5

No luck.

Also tried using 1,2... instead of 901,902

Tried with just 1 buffer and it worked so I know I am not nuts
Quote
Share

TimG
TimG

February 20th, 2013, 7:39 pm #6

I don't think this provides sufficient evidence either way, Dan. :-)

Let me go try on another 11.1.2.2 environment (different OS), will report back in a moment.
Quote
Share

Joined: November 16th, 2003, 11:27 pm

February 20th, 2013, 7:44 pm #7

I am using the syntax as I see it in the DBAG and still getting an error:


IMPORT DATABASE $(APPname).$(DBname) DATA FROM LOAD_BUFFER WITH BUFFER_ID 901,902,903,904,905 ;


in MaxL I get this error:

MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905 ;

essmsh error: Parse error near ,902,903,904,905


I have tried '901,902,903,904,905'

I have tried "901,902,903,904,905"

and putting spaces after the commas. Any ideas???



From the techref:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Commits the contents of multiple data load buffers (buffer_id 1 and buffer_id 2) to the AsoSamp.Sample database.


From the DBAG:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Commits the contents of multiple data load buffers (buffer_id 1 and buffer_id 2) to the AsoSamp.Sample database.
Try

IMPORT DATABASE $(APPname).$(DBname) DATA FROM LOAD_BUFFER WITH BUFFER_ID 901,902,903,904,905 add values;
Quote
Like
Share

Joined: November 16th, 2003, 11:27 pm

February 20th, 2013, 7:50 pm #8

By the way, if you are using 11.1.2.2, it was recently pointed out to me that you can now do this in a single statement/script using a load buffer block


import database 'App'.'DB' data connect as user identified by password
using multiple rules_file 'LD01', 'LD02', 'LD03', 'LD04', 'LD05', 'LD06', 'LD07', 'LD08'
to load_buffer_block starting with buffer_id 100
on error write to '/z/logs/LDALL.err';


No data commit is necessary it does it automatically.
Quote
Like
Share

DanP
DanP

February 20th, 2013, 8:02 pm #9

IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID 901,902,903,904,905 add values;


MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905 add values;

Your second post works with sql input but not with flat files (right?).
Quote
Share

DanP
DanP

February 20th, 2013, 8:08 pm #10

I am using the syntax as I see it in the DBAG and still getting an error:


IMPORT DATABASE $(APPname).$(DBname) DATA FROM LOAD_BUFFER WITH BUFFER_ID 901,902,903,904,905 ;


in MaxL I get this error:

MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905 ;

essmsh error: Parse error near ,902,903,904,905


I have tried '901,902,903,904,905'

I have tried "901,902,903,904,905"

and putting spaces after the commas. Any ideas???



From the techref:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Commits the contents of multiple data load buffers (buffer_id 1 and buffer_id 2) to the AsoSamp.Sample database.


From the DBAG:
import database AsoSamp.Sample data from load_buffer with buffer_id 1, 2;
Commits the contents of multiple data load buffers (buffer_id 1 and buffer_id 2) to the AsoSamp.Sample database.
MAXL> query database ALrgB1.AtrStdDm list load_buffers;

buffer_id internal active resource_usage
aggregation_method ignore_missings ignore_zeros
+-------------------+-------------------+-------------------+-------------------
+-------------------+-------------------+-------------------
901 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE
904 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE
902 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE
903 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE
905 FALSE FALSE 0.2
AGGREGATE_SUM TRUE TRUE

OK/INFO - 1241044 - Records returned: [5].

essmsh timestamp: Wed Feb 20 15:06:21 2013

MAXL> IMPORT DATABASE ALrgB1.AtrStdDm DATA FROM LOAD_BUFFER WITH BUFFER_ID ,902,
903,904,905 add values;

essmsh error: Parse error near ,902,903,904,905

essmsh timestamp: Wed Feb 20 15:06:21 2013


essmsh timestamp: Wed Feb 20 15:06:21 2013
Quote
Share


Confirmation of reply: