BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
thomas29
Fluorite | Level 6

Hello,

I'm administering SAS CSB 5.2 and we are having problems with the size of the scratch data while loading the Foundation Mart. I found out that You can set the Parameter FM_DEBUG to 'N' for the data to be deleted. (Currently it is set to 'Y')

My question, which the Administration Guide does not answer, is: When is the data deleted? After the whole loading is done or when a specific table will not be used again? E.g: Level1 tables are deleted after wave 2 is done, or at the end.

Does anyone have experience on this which thei can share?

 

Thanks in advance.

Kind regards,

 

Thomas

1 ACCEPTED SOLUTION

Accepted Solutions
RaviPoddar
SAS Employee

Tables are deleted once they are not required anymore. 

E.g. Table T1 is created at level 1 and it is used till level 7, it will get deleted at the end of Level 7.

 

Hope this answers your query. 

View solution in original post

2 REPLIES 2
RaviPoddar
SAS Employee

Tables are deleted once they are not required anymore. 

E.g. Table T1 is created at level 1 and it is used till level 7, it will get deleted at the end of Level 7.

 

Hope this answers your query. 

thomas29
Fluorite | Level 6
Thank You, that was exactly what I wanted to know.

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and save with the early bird rate—just $795!

Register now

Discussion stats
  • 2 replies
  • 2439 views
  • 1 like
  • 2 in conversation