dbTalk Databases Forums  

SYSPROC.ADMIN_COPY_SCHEMA

comp.databases.ibm-db2 comp.databases.ibm-db2


Discuss SYSPROC.ADMIN_COPY_SCHEMA in the comp.databases.ibm-db2 forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Mark A
 
Posts: n/a

Default SYSPROC.ADMIN_COPY_SCHEMA - 04-23-2010 , 10:29 AM






Does SYSPROC.ADMIN_COPY_SCHEMA (used to change schema names) work in a DPF
environment? Are the files exported and reloaded with DEL format (not IXF)?

Reply With Quote
  #2  
Old   
Serge Rielau
 
Posts: n/a

Default Re: SYSPROC.ADMIN_COPY_SCHEMA - 04-27-2010 , 11:22 PM






On 4/23/2010 8:59 PM, Mark A wrote:
Quote:
Does SYSPROC.ADMIN_COPY_SCHEMA (used to change schema names) work in a DPF
environment? Are the files exported and reloaded with DEL format (not IXF)?


Mark,

I'm quite certain that it's DEL and I do not see how DPF would play any
role in this context. The procedure operates on the coordinator.

Cheers
Serge



--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab

Reply With Quote
  #3  
Old   
Mark A
 
Posts: n/a

Default Re: SYSPROC.ADMIN_COPY_SCHEMA - 04-28-2010 , 01:30 AM



"Serge Rielau" <srielau (AT) ca (DOT) ibm.com> wrote

Quote:
Mark,

I'm quite certain that it's DEL and I do not see how DPF would play any
role in this context. The procedure operates on the coordinator.

Cheers
Serge
--
Serge Rielau
SQL Architect DB2 for LUW
IBM Toronto Lab
Thanks Serge. A DPF table cannot be loaded (with LOAD command) using IXF
format files (requires DEL).

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.