<Okonita@gmail.com> wrote in message
news:1191975018.234309.203790@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.