COGNOiSe.com - The IBM Cognos Community

ETL, App Development and other tools => COGNOS DecisionStream/Data Manager => Topic started by: abzmanc on 15 Sep 2009 07:10:40 AM

Title: DB2 Load Issue with Data Manager
Post by: abzmanc 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.