We are running some jobs which use hashed lookups. We are getting the following message when resetting the jobs.
Project:prod (adsgp12)
Job name:FactFSRevExp
Event #:196
Timestamp:13/11/2000 11:39:32
Event type:Warning
User:walkerp
Message:
FactFSRevExp.LOOKUP.transaction_category_lookup: add_to_heap() - Unable to create temporary cache file. Check that there is sufficient disk space.
This is even though we have DS variables as set:
aris # /usr/ucb/ps -e -ww 9686
PID TT S TIME COMMAND
9686 ? S 0:00 /app/datastage/P12/ds40/uv/unishared/unirpc/unirpcd
_=/u
sr/bin/nohup MANPATH=/usr/share/man:/opt/SUNWvxva/man:/opt/SUNWvxvm/man:/opt/SUN
Wcluster/man:/opt/SUNWvxva/man:/opt/SUNWpnm/man LANG=C DS_MMAPSIZE=32 PATH=/orac le/P12/bin:/oracle/P12:/usr/sbin:/root/bin:/usr/local/bin:/usr/ccs/bin:/sbin
:/us r/sbin:/usr/bin:/opt/SUNWcluster/bin:/opt/SUNWvxva/bin:/opt/STORtools/bin:/o
pt/S
UNWpnm/bin:/app/datastage/P12/ds40/uv/bin EDITOR=vi LOGNAME=root ORACLE_SID=P12
LOCPATH=/app/datastage/P12/ds40/uv/../branded_odbc/locale PS1=aris # USER=root
TNS_ADMIN=/oracle/P12/network/admin
ODBCHOME=/app/datastage/P12/ds40/uv/../brand
ed_odbc DS_MAXWRITEHEAPS=1 DISPLAY=aphrodite:0 SHELL=/usr/bin/ksh ODBCINI=/app/d atastage/P12/ds40/uv/.odbc.ini HOME=/root LD_LIBRARY_PATH=/app/datastage/P12/ds4
0/uv/lib:/.uvlibs:/oracle/P12/lib TERM=vt220 ORACLE_HOME=/oracle/P12 PWD=/app/da tastage/P12/ds40/uv DS_MMAPPATH=/app/datastage/P12/tmp
ORACLE_BIN=/oracle/P12/bi
n
This is the stats for the filesystems:
aris # df -k
Filesystem kbytes used avail capacity Mounted on
/dev/vx/dsk/rootvol 2055705 1111582 882452 56% /
/proc 0 0 0 0% /proc
fd 0 0 0 0% /dev/fd
/dev/vx/dsk/var 1527116 1215834 250198 83% /var
/dev/vx/dsk/other 8701910 8346549 268342 97% /other
/dev/vx/dsk/swap 2490434 2490249 0 100% /swap
/dev/vx/dsk/tmp 493688 315178 129142 71% /tmp
/dev/vx/dsk/aorap12/datastage_P12
26517504 4319848 21850832 17% /app/datastage/P12
chris:/home/ftp 139264 16240 123024 12% /nfs-client/chris
woody:/NMX/CHHWP_LIVE/NMX_DB/SSCS/SapDataOutput
16121856 11527656 4594200 72% /nfs-client/woody
/dev/vx/dsk/aorap12/oracle_P12
26517504 5999512 20197452 23% /oracle/P12
sun-home:/export/sun-home
8573112 3811424 4675960 45% /people/sun-home
Heap(s) of errors
Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.
Return to “Archive of DataStage Users@Oliver.com”
Jump to
- Moderators' Choice
- ↳ Editor's BLOG Corner
- ↳ Ask the Experts! - Dads and Grads
- ↳ DSXchange Testimonials
- ↳ Cognos (IBM BI)
- FAQs
- ↳ FAQs
- ↳ FAQ Discussion
- DataStage
- ↳ General
- ↳ IBM<sup>®</sup> Infosphere DataStage Server Edition
- ↳ IBM<sup>®</sup> DataStage Enterprise Edition (Formerly Parallel Extender/PX)
- ↳ Archive of DataStage Users@Oliver.com
- IBM<sup>®</sup>Infosphere Products<sup></sup>
- ↳ Business Glossary
- Suggestions
- ↳ Site/Forum
- ↳ Enhancement Wish List
- Consulting
- ↳ Talent
- ↳ Looking for Talent
- Support
- ↳ Parameter Manager
- ↳ Compile All Plus
- Usergroup Forums
- ↳ Usergroup Central Forum
- ↳ Heartland Usergroup Forum
- The Written Word
- ↳ Articles, White Papers and Tips and Tricks
- ↳ Product Documentation
- Third Party Applications
- ↳ Third Party Applications
- Product Derivatives
- ↳ Functions
- ↳ Routines
- ↳ Jobs
- ↳ Logs
- Tools
- ↳ Tools Forum
- Category
- ↳ Infosphere Master Data Management
- ↳ Data Quality Best Practices
- ↳ IBM QualityStage
- ↳ Information Analyzer (formerly ProfileStage)
- ↳ IBM<sup>®</sup> SOA Editions (Formerly RTI Services)
- ↳ IBM<sup>®</sup> DataStage TX
- ↳ BI
- ↳ Data Integration