Heap(s) of errors

Archive of postings to DataStageUsers@Oliver.com. This forum intended only as a reference and cannot be posted to.

Moderators: chulett, rschirm

Locked
admin
Posts: 8720
Joined: Sun Jan 12, 2003 11:26 pm

Heap(s) of errors

Post by admin »

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
Locked