The following request creates SPOOL with a size based on the constant expression 2,000,000 (HASHAMP()+1). The expression calculates the number of AMPs in the current system and scales the SPOOL space for the research_and_development profile to that size.
CREATE PROFILE research_and_development AS DEFAULT DATABASE = it_dev, PASSWORD = (EXPIRE = 0), SPOOL = 2000000*(HASHAMP()+1);