|
Data Modeling -
ETL DataStage
|
|
Written by Roceller Alvarez
|
|
Friday, 19 January 2007 |
DataStage Error:
Error calling subroutine: *DataStage*DSR.ADMIN (Action=10); check DataStage is set up correctly in project IRMPBAPMart
(The connection is broken (81002))
|
|
Read more...
|
|
|
Data Modeling -
ETL DataStage
|
|
Written by Roceller Alvarez
|
|
Tuesday, 26 September 2006 |
You will get this error if the Job Monitor is down. The job monitor is a seperate Java application that monitors running jobs on DataStage.
You can actually stop and start this job monitor.
|
|
Read more...
|
|
|
Data Modeling -
ETL DataStage
|
|
Written by Roceller Alvarez
|
|
Tuesday, 26 September 2006 |
If you changed your uvconfig values, for example the T30FILE, you would need to do uvregen. But you will probably get an error saying...
Disk shared memory size of 13187020 exceeds maximum allowed size of 11829248
This is because, the shared memory settings DMEMOFF also needs to be adjusted. But what is the right value?
|
|
Read more...
|
|
|
Data Modeling -
ETL DataStage
|
|
Written by Roceller Alvarez
|
|
Monday, 25 September 2006 |
This means that the number of opened dynamic files exceeded the settings in uvconfig. This may also due to hung process that wasn't relased from the table. Typically, a simple restart of the DataStage server will resolve this issue. But you may also want to increase the value of T30FILE from the uvconfig.
To change this value, edit uvconfig file. The default is 200. Bump it up to 500 and play with the settings over time. If you still received the same error, just adjust the settings again.
|
|
Read more...
|
|
|
Programming -
Shell Scripts
|
|
Written by Roceller Alvarez
|
|
Tuesday, 16 May 2006 |
To delete old files in unix, you can execute the following command from the shell:
find <path> -mtime +30 -exec rm -f {} \;
For example, to delete all file more than 30 days older:
find /tmp -mtime +30 -exec rm -f {} \;
Write Comment (0 Comments) |
|
Read more...
|
|
|
Data Modeling -
ETL DataStage
|
|
Written by Roceller Alvarez
|
|
Thursday, 16 March 2006 |
Here's a quick tip on how to get a date in string YYYYMMDD format from ETL DataStage server job. Apparently using Oconv(@DATE, "DYMD[4,2,2]") will not produce a date in YYYYMMDD format as expected. It will produce YYYY MM DD (with space in between).
|
|
Read more...
|
|
|
Data Modeling -
ETL DataStage
|
|
Written by Roceller Alvarez
|
|
Monday, 13 March 2006 |
This is a quick tip on how you would do date operation in a Parallel Extender job. The date needs to be converted first to Julian date which is an integer, then convert back to date after doing the mathematical operation.
|
|
Read more...
|
|
|
Data Modeling -
Data Warehouse
|
|
Written by Roceller Alvarez
|
|
Monday, 13 March 2006 |
A snowflake schema is a star schema structure normalized through the use of dimension tables. For example dimension table hierachies are broken into simpler tables. In star schema example we had 4 dimensions like customer, time, store, product and sales fact table.
|
|
Read more...
|
|
|
Networking & Security -
Security
|
|
Written by Russel Boyd
|
|
Sunday, 12 March 2006 |
BFD is a modular shell script for parsing applicable logs and checking for authentication failures. There is not much complexity or detail to BFD yet and likewise it is very straight-forward in its installation, configuration and usage. The reason behind BFD is very simple; the fact there is little to no authentication and brute force auditing programs in the linux community that work in conjunction with a firewall or real-time facility to place bans.
Note: BFD default configuration is designed to work in conjunction with APF versions 0.9.3+.
|
|
Read more...
|
|
|
<< Start < Prev 1 2 3 4 Next > End >>
|
| Results 1 - 9 of 35 |
