Hi,
I am creating a hash file with 3 million records and its following error:
"HASH_DW_GRID..HASH_DW_GRID_APIGG.loDW_GRID: DSD.UVOpen mkdbfile: cannot create file /vol02/home/dsadm/hash/DW_GRID_APIGG"
This hash file job was running successfully till yesterday and no changes has been made in the DS code.
If I run other hash files with less data no problem is coming up.
Any thoughts why this error is coming.
Cheers
Hash file not getting created
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 27
- Joined: Fri Jul 28, 2006 2:11 pm
Hash file not getting created
Sunshine
-
- Charter Member
- Posts: 6
- Joined: Thu Mar 27, 2003 1:55 pm
- Contact:
If your data volume today is close to before then perhaps the create error message has to do with Unix file permissions. I'd suggest that you verify that the login you are using has the correct Unix permissions to create/modify the hashed data file (and/or its directory location). If your permissions are okay then you may be trying to create a hashed data file that is larger than your maximum 2 gig or 4 gig Unix file size limit.
Mark Ott
DataStage Architect
Adept Technologies, Inc.
DataStage Architect
Adept Technologies, Inc.
-
- Participant
- Posts: 32
- Joined: Fri Dec 02, 2005 10:44 pm
- Location: Chicago,IL
Re: Hash file not getting created
amitendra_amit wrote:Hi,
I am creating a hash file with 3 million records and its following error:
"HASH_DW_GRID..HASH_DW_GRID_APIGG.loDW_GRID: DSD.UVOpen mkdbfile: cannot create file /vol02/home/dsadm/hash/DW_GRID_APIGG"
This hash file job was running successfully till yesterday and no changes has been made in the DS code.
If I run other hash files with less data no problem is coming up.
Any thoughts why this error is coming.
Cheers
Hi there,
For Hash File Stage:
If you have to create the file for each run,set it to 'clear before writing' or if there are any custom standards,check the create file in general tab.then go to the options and set it accordingly
Thanks,
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
Pradeep
(Ten Hugs And Nine KisseS - THANKS)......is that true?
In GOD we trust,for all others we take cash.
-
- Participant
- Posts: 40
- Joined: Sun Jan 21, 2007 1:52 pm
- Location: Chennai
- Contact:
Re: Hash file not getting created
Hi,pradeepleon wrote:amitendra_amit wrote:Hi,
I am creating a hash file with 3 million records and its following error:
"HASH_DW_GRID..HASH_DW_GRID_APIGG.loDW_GRID: DSD.UVOpen mkdbfile: cannot create file /vol02/home/dsadm/hash/DW_GRID_APIGG"
This hash file job was running successfully till yesterday and no changes has been made in the DS code.
If I run other hash files with less data no problem is coming up.
Any thoughts why this error is coming.
Cheers
Hi there,
For Hash File Stage:
If you have to create the file for each run,set it to 'clear before writing' or if there are any custom standards,check the create file in general tab.then go to the options and set it accordingly
I echo the same as pradeep, we need to check the option "clear file before creation", other than that, i would like to point one more thing, Since you have stated as 3 million records, may be while it was working for previous runs, the storage space might be full and no space left in device. This prevents from creation of file and job aborts . You can also verify the same.
regards
Murugan