The High-Performance Analytics sample programs and install verification tests can only be run after you edit and submit this file. The file contains site-specific information about your environment so that the procedures can run successfully.
/*--------------------------------------------------------------*/ /*- This file must be run prior to executing the HPA install -*/ /*- tests or HPA sample programs. -*/ /*- -*/ /*- You must input the correct values for your site for: -*/ /*- GRIDHOST=, GRIDINSTALLLOC=, ENGINE=, USER=, -*/ /*- PASSWORD=, and DATABASE=. -*/ /*- -*/ /*- Additionally, if running on: -*/ /* Teradata Appliance, input value for GRIDDATASERVER=. -*/ /*- Greenplum Appliance, input value for SCHEMA=. -*/ /*--------------------------------------------------------------*/ %let GRIDHOST =; %let GRIDINSTALLLOC= ; %let ENGINE = ; %let USER = ; %let PASSWORD = ; %let DATABASE = ; /* enter for GRIDDATASERVER only if using a Teradata appliance */ %let GRIDDATASERVER=/* */; /* enter for SCHEMA only if using a Greenplum appliance */ %let SCHEMA=/* */; /********************************************************************/ /* DO NOT MODIFY ANYTHING BELOW THIS LINE */ /********************************************************************/ /*------------------------------------------------------------*/ /*- Some cleanup code depending on what appliance is used -*/ /*------------------------------------------------------------*/ %macro appliance; %if %upcase(&engine)=TERADATA %then %do; options set=GRIDDATASERVER="&GRIDDATASERVER"; %end; %else %if %upcase(&engine)=GREENPLM %then %do; %let DATABASE = &DATABASE SCHEMA=&SCHEMA; %let GRIDDATASERVER = &GRIDHOST; %end; %mend; %appliance; /*------------------------------------------------------------*/ /*- Creating libname statement for running alongside the DB -*/ /*------------------------------------------------------------*/ libname GridLib &engine SERVER ="&GRIDDATASERVER" USER =&USER PASSWORD=&PASSWORD DATABASE=&DATABASE; %let LIBTYPE = &ENGINE; /*------------------------------------------------------------*/ /*- HPATEST run to check grid and assign macro variable -*/ /*- HPA_ENABLED which is used for NODES= value in the -*/ /*- PERFORMANCE statement of the procedure runs. -*/ /*------------------------------------------------------------*/ ods listing close; proc hpatest; performance nodes=ALL HOST="&GRIDHOST" INSTALLLOC="&GRIDINSTALLLOC"; run; ods listing; %let PERFORMANCE_OPTS=NODES=&HPA_ENABLED host="&GRIDHOST" installloc="&GRIDINSTALLLOC";