Hi Stephen, [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] wrote:
> > One interesting side comment on this: I am starting with an > empty database on target server. I am ONLY doing 'create > table' with primary key, not > issuing any of my 'create indexes'. I am NOT using th catalog > created by DBEXTRACT. However, I am surprised to find that > after I do my TABELOAD > (PAGES) that all indexes are there on the target. Attempts > to create the optoinal named indexes after the tableload say > they already exist. I would > have guessed that the CATALOG was resposible for indexes... > but testing proves otherwise? > Yes, right. Even if there would be indexes created by CATALOGLOAD the TABLELOAD command would drop them first then load the data and then recreate the indexes. The data files created at TABLEEXTRACT contain all information to do this. Oh yes - only in format PAGES because using this format the Loader loads the data directly into the tree structures of the database without logging. In format RECORDS simply mass inserts are done. > Please do! It would be great to have the ability to snapshot > production data only specific tables without down time or > having to do a full backup. Right > now, the only method I know of would be to work with SQL > SELECT and build our own 'loadercli' type tool, correct? > Yes, partially correct. At the moment there is no way to avoid the table locks on extracting/loading a specific table. But there is a (hidden) command you could use on your target db to avoid a backup after having the data loaded: set nolog off. You need to run this as a utility command, which means: dbmcli -u <user,pw> -d <db name> util_connect util_execute set nolog off util_release exit After having done this all tables are writable again. But the data is completely lost in case of crash. > Luckily I have worked with SAP off and on since 1990 and have > grown to know the German sense of humor :) > And I always thought my sense of humor is more English like ... Best regards, Steffen -- Steffen Schildberg SAP DB Team SAP Labs Berlin -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
