Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

MaxDB tables are ReadOnly after DBLOAD

Posted on 2005-04-23
2
Medium Priority
?
463 Views
Last Modified: 2012-06-21
I have what I hope is a very simple problem.  I'm trying to export the data from a MaxDB (SAP) database and then load that data into another MaxDB database on another machine.  The dbextract runs just fine and so does the dbload to the MaxDB database on the second machine. However, on the second machine, the MaxDB database is readOnly.  I can't insert, modify or delete rows on any of the tables in the second MaxDB database.  

The question is, what do I need to do to make the tables in the MaxDB database on the second machine not read only.

This is the command I used to extract the data:

DBEXTRACT
CATALOG OUTSTREAM FILE'C:\apps\xport\DW.LOG'
DATA OUTSTREAM FILE'C:\apps\xport\DW.DATA'

This is the command I used to load the data:

DBLOAD
CATALOG INSTREAM FILE 'C:\apps\xport\DW.LOG'
DATA INSTREAM FILE 'C:\apps\xport\DW.DATA'

Thank you , in advance, for the expert exchange.
0
Comment
Question by:HycelTaylor
1 Comment
 

Accepted Solution

by:
HycelTaylor earned 0 total points
ID: 13851698
I found a solution at http://lists.mysql.com/maxdb/17701.
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

When table data gets too large to manage or queries take too long to execute the solution is often to buy bigger hardware or assign more CPUs and memory resources to the machine to solve the problem. However, the best, cheapest and most effective so…
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Suggested Courses
Course of the Month21 days, 1 hour left to enroll

810 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question