By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
431,943 Members | 1,890 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 431,943 IT Pros & Developers. It's quick & easy.

Can a flat dataset from a DSN1COPY run be used to Load a DB2 table? and other questions...

P: n/a
Hello all,

I have a question about loading DB2. I ran a DSN1COPY against a
imagecopy of 1 tablespace and the output to a flat file instead of the
original DB2 VSAM dataset. Can I use this flat file to load a DB2
table that was dropped and recreated? In this shop, not everyone has
authority to work directly with the underlying DB2 VSAM datasets for
security reasons.

How can one find out from a imagecopy the OBID of the table in that
copy?

Can you create a table and assign the new table a specific OBID? e.g
444

Thank you all for your responses
Can a flat dataset from a DSN1COPY run be used to Load a DB2 table?
and other questions...

Oct 10 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
<Ok*****@gmail.comwrote in message
news:11**********************@19g2000hsx.googlegro ups.com...
Hello all,

I have a question about loading DB2. I ran a DSN1COPY against a
imagecopy of 1 tablespace and the output to a flat file instead of the
original DB2 VSAM dataset. Can I use this flat file to load a DB2
table that was dropped and recreated? In this shop, not everyone has
authority to work directly with the underlying DB2 VSAM datasets for
security reasons.

How can one find out from a imagecopy the OBID of the table in that
copy?

Can you create a table and assign the new table a specific OBID? e.g
444

Thank you all for your responses

Can a flat dataset from a DSN1COPY run be used to Load a DB2 table?
and other questions...
Yes, you can use the output of DSN1COPY to load an existing table. The
original VSAM dataset is actually worthless, even if you could access it.

You can find out the OBID of the original table and the table to be loaded.
I forgot how, but do a search or look in the manuals.

Last time I looked, you cannot specify a specific obid when creating a
table.
Oct 10 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.