FLOAD Not initializing

Database

FLOAD Not initializing

Hi Guru's

i recently came across this particular problem:

Problem:
======
a developor started an informatica job which reads the source file and inserts the data into Target STG table using fastload. Although he see no problem with the source being read his concern is that FL is not initialised.

My approach:
==========

When i checked on the Dev machine.. i saw around lot of MLOAD/FLOAD sessions. So i was observing the TD manager and i saw almost all the FLOAD and MLOAD were idle sessions and delta cpu was 0 which is a clear indication.
i checked with other developors and ensured no one was running any loading jobs.

My 2nd thought was to see if Loader slots were available or not.

i checked few things:
1> i ran TOP command and found system was 95% idle.

2> i ran puma -m
#
MbxId Part Vproc Owner MsgCount MbxName Flags MsgDQCount
85 2 16384 23896 1 8-2 Signal 6

3> i ran puma -c

VPROC = 0
WorkType Min Max Inuse Peak
MSGWORKNEW 3 50 1 16
MSGWORKONE 3 999 1 15
MSGWORKTWO 3 999 0 13
MSGWORKTHREE 3 999 0 7
MSGWORKFOUR 0 999 1 1
MSGWORKFIVE 0 999 0 1
MSGWORKSIX 0 999 0 1
MSGWORKSEVEN 0 999 0 0
MSGWORKEIGHT 0 999 0 0
MSGWORKNINE 0 999 0 0
MSGWORKTEN 0 999 0 0
MSGWORKELEVEN 0 999 0 0
MSGWORKABORT 3 999 0 4
MSGWORKSPAWN 3 999 0 5
MSGWORKNORMAL 3 999 0 7
MSGWORKCONTROL 3 999 0 6

VPROC = 1
WorkType Min Max Inuse Peak
MSGWORKNEW 3 50 1 15
MSGWORKONE 3 999 1 15
MSGWORKTWO 3 999 0 13
MSGWORKTHREE 3 999 0 7
MSGWORKFOUR 0 999 0 0
MSGWORKFIVE 0 999 0 1
MSGWORKSIX 0 999 0 1
MSGWORKSEVEN 0 999 0 0
MSGWORKEIGHT 0 999 0 0
MSGWORKNINE 0 999 0 0
MSGWORKTEN 0 999 0 0
MSGWORKELEVEN 0 999 0 0
MSGWORKABORT 3 999 0 3
MSGWORKSPAWN 3 999 0 5
MSGWORKNORMAL 3 999 0 2
MSGWORKCONTROL 3 999 0 6

My Dev system is a one node 12 amp system. for remaining vprocs also the same

My question :

for Puma -c ..what should i obvserve? inuse was almost nothing. Does it mean that Awt's were free?

Does idle sessions eat up awt? there were about 140 idle Fload and Mload sessions....

how do we see if 15 loader slots are occupied or not?

regards
TD_DBA