OSEC

Neohapsis is currently accepting applications for employment. For more information, please visit our website www.neohapsis.com or email hr@neohapsis.com
 
DBExtract in LoaderCLI for Version 7.6 not extracting any data

From: Hycel Taylor (hycel1gmail.com)
Date: Wed Sep 21 2005 - 09:32:21 CDT


Hello,

I have just moved from MaxDB 7.5 to MaxDB 7.6. I installed version
7.6 on a new box, created my database and ran a set of java classes to
load data from my ASA database to my MaxDB database instance
(50,000,000 rows, in 111 tables). The migration when fine just like
it always did with version 7.5. I then tried to do an export just
like I would do with version 7.5.

The commands I use are the following:

> loadercli -d TEST -u DBA,SYSDBA

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

After logging into the loadercli, and executing the second command, in
version 7.5, all of the data from the TEST database instance is
exported successfully. When I execute these exact same commands for
version 7.6, nothing gets exported. In the log file, I get the
following information:

// M Loader 7.6.00 Build 012-123-102-632
// *
// M Module: C:\Program Files\sdb\programs\bin\loadercli.exe
// *
// M Loader instance started at MALCOMI for database TEST
// *
// M Starting protocol at 2005092100070540
// *
// M START 20050921 00070540
// *
SET
// *
// M START 20050921 00070540
// *
USE USER "DBA" * SCHEMA DBA SERVERDB "TEST"
// *
// M USER: 'DBA' on DB: 'TEST' ISOLATION LEVEL: 3
// *
// M START 20050921 00070635
// *
DBEXTRACT CATALOG OUTSTREAM FILE 'C:\apps\xport\TEST.LOG' DATA
OUTSTREAM FILE 'C:\apps\xport\TEST.DATA'
// *
// M Import PACKAGE x'01000000BBCF41F964010000A931000091D733E126F2D19D'
// *
// M Execute PACKAGE to transform CATALOG
/ *
// M Number of TABLES to transform: 0
// *
// M Number of VIEWS to transform: 0
// *
// M Number of SYNONYMS to transform: 0
// *
// M Number of TABLES transformed : 0
// *
// M Import PACKAGE x'01000000BBCF41F964010000A931000091D733E126F2D19D'
// *
// M Execute PACKAGE to transform DATA
// *
// M Number of TABLES to transform: 0
// *
// M Number of TABLES transformed : 0
// *
// M Export PACKAGE x'01000000BBCF41F964010000A931000091D733E126F2D19D'
// *

Does any one know why this is happening and what I must do to fix it?

Thanks, in advance to anyone who can help me solve this issue.

--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb