The SQLDUMP utility is extended to support multi-tenancy. This utility allows you to dump data from multi-tenant tables—depending on the user type—to an external file with the new (- n) command line option. The following examples provide clarity on dumping multi-tenant tables:

The following example directs the SQLDUMP utility to dump data from the tenants ten1 and ten2 to two SQL dump files respectively. The user_name and password to connect to the database are supertenUser@superdom and superten. The supertenUser account in the superdom domain must have the authority to access the mttab1 table and the _tenant system table in mtdb database.

To separate the tenant specific data the SQLDUMP utility creates separate directories for each tenant. ten1/<OWNER>.MTTAB1.DSQL and ten2/<OWNER>.MTTAB1.DSQL are the two directories that are created to dump tenant data.

Example: SQLDUMP from multi-tenant tables 

sqldump -u supertenUser@superdom -a superten  -t mttab1 -n ten1,ten2 progress:T:localhost:9999:mtdb

If the regTenantUser is mapped to a regular tenant, then the following example directs the SQLDUMP utility to dump the data for the regTenantUser tenant's partition.

Example: SQLDUMP by a regular tenant 

sqldump -u regTenantUser@OpenEdgeA -a regTenant -t mttab1 progress:T:localhost:9999:mtdb

If the regTenantUser is mapped to a regular tenant, then the following example directs the SQLDUMP utility to dump the data for the regTenantUser tenant's partition. 

sqldump -u regTenantUser@OpenEdgeA -a regTenant -t mttab1 -n ten1 progress:T:localhost:9999:mtdb

If regTenantUser is not mapped to ten1 tenant, the above statement throws an error.

Example: SQLDUMP by a DBA

If the dbaUser is a DBA, then, the following example directs the SQLDUMP utility to dump the tenant-specific data for all the tenants in their respective directory.

sqldump -u dbaUser -a dba -t mttab1 progress:T:localhost:9999:mtdb

If the superTenUser is a super-tenant, then, the following example directs the SQLDUMP utility to dump all the tenants which start with the word ‘ten' from the table mttab.

Example: SQLDUMP using a % operator 

sqldump -u superTenUser@superdom -a superten -t mttab1 -n ten% progress:T:localhost:9999:mtdb

If the dbaUser is a DBA, then the following example directs the SQLDUMP utility to dump all the tenants which start with the word ‘ten' from all the tables that start with mttab.

sqldump -u dbaUser -a dba -t mttab% -n ten% progress:T:localhost:9999:mtdb