This Essbase discussion board is provided as a free service and dedicated to all the Essbase professionals out there!
 Return to Index  

Ran a Query database List load_buffers to prove they exist

February 20 2013 at 3:08 PM
No score for this post
DanP 
from IP address 108.5.149.202


Response to Parallel ASO Load - Multiple Buffers

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

 
Scoring disabled. You must be logged in to score posts.Respond to this message   
Responses

  1. Re: Ran a Query database List load_buffers to prove they exist - TimG on Feb 20, 2013, 4:29 PM
    1. Works in EAS Editor - DanP on Feb 20, 2013, 4:46 PM
      1. Solved - You will not believe! - DanP on Feb 20, 2013, 5:37 PM
        1. Re: Solved - You will not believe! - TimG on Feb 20, 2013, 5:48 PM
     

RSS feed for this forum - http://www.network54.com/Forum/58296?xml=rss. Please email hypess (at) gmail.com, if you have any questions/feedback/issues.