Hi,
I was writing a hash file for delta the number of rows are like 1,459,394
and its adding 3200/day, My allow stage cache create file is marked ,
i was wondering whts max number of records hash file can have .
Plz advice.
Thanxs
Bobby
hash file capacity
Moderators: chulett, rschirm, roy
-
ray.wurlod
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
There's no limit based on number of rows.
However, the default hashed file has an upper limit of 2GB; you need to prevent it from hitting that barrier or it will become corrupted. Monitor the size and, if it exceeds, say, 1.5GB, take action to convert its internal pointers from 32-bit to 64-bit pointers.
Search the forum for RESIZE when you need the command for achieving this.
However, the default hashed file has an upper limit of 2GB; you need to prevent it from hitting that barrier or it will become corrupted. Monitor the size and, if it exceeds, say, 1.5GB, take action to convert its internal pointers from 32-bit to 64-bit pointers.
Search the forum for RESIZE when you need the command for achieving this.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.