The excerpt from the script
.BEGIN IMPORT MLOAD TABLES db.db
ERRORTABLES db.ET_db db.UV_db
From the above the no. of sessions declared is 12. Following the loader log indicating the number of sessions as 33.
= MultiLoad Initial Phase =
**** 01:17:29 UTY0829 Options in effect for this MultiLoad import task:
. Sessions: 12 session(s).
. Checkpoint: No rate in effect.
. Tenacity: 10000 hour limit to successfully connect load
. Sleep : 6 minute(s).
. Errlimit: No limit in effect.
. AmpCheck: In effect for apply phase transitions.
**** 01:17:29 UTY0844 Session count 33 returned by the DBS overrides
user-requested session count.
**** 01:17:38 UTY0812 MLOAD session(s) requested: 33.
**** 01:17:38 UTY0815 MLOAD session(s) connected: 33.
Where can I find the value for DBS that override the user specified session count?
If you are working on Teradata 13.10 or above then the session limits specified in TASM will override the limits that you have set in you Multiload script. In your case the TASM session rule would enforce a session count of 33 which is overriding the session count in your script.
For more info on this you could read this excellent article
Hope it helps