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

[Okonita]

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...

[Mark 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.