Author Topic: DB2 Load Issue with Data Manager  (Read 3299 times)

Offline abzmanc

  • Associate
  • **
  • Join Date: Sep 2009
  • Posts: 1
  • Forum Citizenship: +0/-0
DB2 Load Issue with Data Manager
« on: 15 Sep 2009 07:10:40 am »
Hi All, new guy here, got a query RE Data Manager.

DBA has set up a database for us, now im creating Fact and Dimension Builds within Data Manager. I can run the Dimension Build Jobs just fine and the tables will be created/populated. When I do this with the Fact Build the Table is created but will not populate, it gives me the following error...

-----Delivery 'F_Problem_Ticket': DB2 LOAD Output file-----

   Database Connection Information

 Database server        = DB2/LINUXX8664 9.5.4

 SQL authorization ID   = COG_ADM

 Local database alias   = STAR_DB

SQL3025N  A parameter specifying a filename or path is not valid.

DM-D2L-0060 The delivery 'F_Problem_Ticket': DB2 LOAD process failed (status 4).

DM-BLD-0005 The delivery 'F_Problem_Ticket' failed.

[PROGRESS   - 13:03:51] Build 'F_Problem_Ticket' Failed
databuild -- failed (15-Sep-2009 13:03:51)

Anybody here come across something similar before?? Have no idea what to do, DBA doesnt have an immediate solution either.