Loading Data from SYSCNTL and SYSREC files

[heather.j.mills]

I received a DVD worth of DB2 files of the structure:

TblName.SYSCNTL
TblName.SYSREC

I have no experience with DB2, but am pretty strong in SQL. I see
that the CNTL are table definition type files and the REC the data.
How do I use this two files to reconstruct a database? Ideally I want
to work with data in SQL Server Management Studio -- but loading in
DB2 I figured was the first step.

Thanks.

[The Boss]

he*************@gmail.com wrote:

I received a DVD worth of DB2 files of the structure:

TblName.SYSCNTL
TblName.SYSREC

I have no experience with DB2, but am pretty strong in SQL. I see
that the CNTL are table definition type files and the REC the data.
How do I use this two files to reconstruct a database? Ideally I want
to work with data in SQL Server Management Studio -- but loading in
DB2 I figured was the first step.

Thanks.

Do you have a mainframe?
You can't use these to reconstruct a database.
The SYSCNTL's and SYSREC's are created via BMC UnloadPlus, a third party
program to unload DB2 for z/OS tables into a format suitable for BMC
LoadPlus to (re)load the data into the same or another DB2 for z/OS
database.
The SYSREC contains the table data, the SYSCNTL contains the LOAD statement
and includes formatting statements that map the layout of the SYSREC to the
corresponding DB2 table.
What you need besides these files (and a mainframe with DB2 and BMC
Utils...) are the actual create statements for the database (tablespaces,
tables, indexes, etc..)

HTH

--
Jeroen