when i write a JCL script for an MLOAD, usually i specify the dBs wheret the error/work tables are to be created. But i dont specify one for the Log table. In that case, where does it get created? As in, what is the default dB and how can that be changed?
The following is a sample script... //SYSIN DD DATA,DLM=## .DATEFORM ANSIDATE; .LOGTABLE ML_TGT_TABLE; .LOGON TDP1/USER,PWD; RELEASE MLOAD TEST_DB.TGT_TABLE; DELETE TEST_DB.TGT_TABLE all; DROP TABLE TEST_DB.UV_TGT_TABLE; DROP TABLE TEST_DB.WT_TGT_TABLE; DROP TABLE TEST_DB.ET_TGT_TABLE;
Here the Error/Work/Target tables get created in TEST_DB whereas i want to know where to find the default dB where the Log table ML_TGT_TABLE will be created.