creating a blank table
Posted: Fri Jul 21, 2006 8:36 am
Does anyone know of a way to do this an ODBC stage? The reason for this is that, we need a job that will create and load a table on a DB2 system.
The table gets created but bombs when trying to load data. The error message points to a journaling issue. The table is not being journaled when it is created. We found out that it DOES get journaled by the DB2 system about 5 minutes after it is created.
So my thought was to created two different jobs, the first to create the table. The next job would load the table 10 - 20 minutes after the first job runs, allowing time for journaling to take place.
Any help would be greatly appreciated.
The table gets created but bombs when trying to load data. The error message points to a journaling issue. The table is not being journaled when it is created. We found out that it DOES get journaled by the DB2 system about 5 minutes after it is created.
So my thought was to created two different jobs, the first to create the table. The next job would load the table 10 - 20 minutes after the first job runs, allowing time for journaling to take place.
Any help would be greatly appreciated.