Staging Parameters for Supported Adapters

The following tables show the staging parameters for each adapter that SAS IT Resource Management supports. These staging parameters are available from the Adapter Setup wizard and from the Staging Parameters tab of the Properties dialog box for an adapter or staging transformation.

ASG TMONC2CIC Staging and Duplicate-Data Checking Parameters

Staging Parameters for the ASG TMONC2CIC Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input file
any valid file
none
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VBS and LRECL=32760
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking parameters for the ASG TMONC2CIC Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:00
KEEP
any integer
26
REPORT
Yes
No
Yes

ASG TMONDB2 Staging and Duplicate-Data Checking Parameters

Staging Parameters for the ASG TMONDB2 Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input file
any valid file
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VBS and LRECL=32760
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the ASG TMONDB2 Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:00
KEEP
any integer
26
REPORT
Yes
No
Yes

BMC Mainview IMS Staging and Duplicate-Data Checking Parameters

Staging Parameters for the BMC Mainview IMS Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input type
File (default)
Raw data input file
any valid file
FTP
Host
any valid host
Port
any valid port
21
User
any valid user
Password
any valid password
External file name
any valid file
Tape
Yes
No
No
RCMD
any valid site
SITE RDW
Debug
Yes
No
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VBS and LRECL=32760
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the BMC Mainview IMS Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:00
KEEP
any integer
26
REPORT
Yes
No
Yes

BMC Perf Mgr Staging and Duplicate-Data Checking Parameters

Staging Parameters for the BMC Perf Mgr Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input file
any valid file
Allow duplicate ID variables
Yes
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VBS and LRECL=32760
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the BMC Perf Mgr Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
00:18
KEEP
any integer
52
REPORT
Yes
No
Yes

CA TMS Staging and Duplicate-Data Checking Parameters

Staging Parameters for the CA TMS Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input type
File (default)
Raw data input file
any valid file
FTP
Host
any valid host
Port
any valid port
21
User
any valid user
Password
any valid password
External file name
any valid file
Tape
Yes
No
No
RCMD
any valid site
SITE RDW
Debug
Yes
No
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VB and LRECL=16384
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the CA TMS Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
25:00
KEEP
any integer
26
REPORT
Yes
No
Yes

CSV Staging and Duplicate-Data Checking Parameters

Staging Parameters for the CSV Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input file or directory
any valid file or directory
The CSV adapter does not support non-ASCII characters in the heading columns. For more information, see Accessing CSV Files That Contain Data Encoded in UTF-8.
Type of delimiter
list of delimiter characters
delimiter string
list of delimiter characters
Delimiter characters
any characters
,
Delimiter string
any characters
Is the delimiter string case sensitive?
Yes
Only available if Type of delimiter is Delimiter string.
Is there a header row?
Yes
What row is the header on?
1
What row does the data start on?
any integer
any integer
How many rows of data should be used as guessing rows?
20
Future data
Discard
Duplicate-Data Checking Parameters for the CSV Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
IDVAR
SAS variable
FILENAME
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:15
KEEP
any integer
52
REPORT
Yes
No
Yes

DT Perf Sentry Staging and Duplicate-Data Checking Parameters

Staging Parameters for the DT Perf Sentry Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input file or directory
any valid file or directory
Delimiter in raw data
Comma
Tab
Comma
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the DT Perf Sentry Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:18
KEEP
any integer
52
REPORT
Yes
No
Yes

DT Perf Sentry with MXG Staging and Duplicate-Data Checking Parameters

Staging Parameters for the DT Perf Sentry with MXG Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input type
File (default)
Raw data input file
any valid file
FTP
Host
any valid host
Port
any valid port
21
User
any valid user
Password
any valid password
External file name
any valid file
Tape
Yes
No
No
RCMD
any valid site
SITE RDW
Debug
Yes
No
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=V and LRECL=32756
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the DT Perf Sentry with MXG Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:00
KEEP
any integer
26
REPORT
Yes
No
Yes

HP Perf Agent Staging and Duplicate-Data Checking Parameters

Staging Parameters for the HP Perf Agent Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input file or directory
any valid file or directory
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the HP Perf Agent Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:05
KEEP
any integer
52
REPORT
Yes
No
Yes

HP Reporter Staging and Duplicate-Data Checking Parameters

Staging Parameters for the HP Reporter Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input library: Library and Libref
any valid library and libref
Future data
Accept
Discard
Terminate
Discard
Default duration
0 or greater
0
Duplicate-Data Checking Parameters for the HP Reporter Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:05
KEEP
any integer
260
REPORT
Yes
No
Yes

IBM DCOLLECT Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM DCOLLECT Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input type
File (default)
Raw data input file
any valid file
FTP
Host
any valid host
Port
any valid port
21
User
any valid user
Password
any valid password
External file name
any valid file
Tape
Yes
No
No
RCMD
any valid site
SITE RDW
Debug
Yes
No
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VB and LRECL=16384
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the IBM DCOLLECT Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
26:00
KEEP
any integer
26
REPORT
Yes
No
Yes

IBM EREP Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM EREP Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input type
File (default)
Raw data input file
any valid file
FTP
Host
any valid host
Port
any valid port
21
User
any valid user
Password
any valid password
External file name
any valid file
Tape
Yes
No
No
RCMD
any valid site
SITE RDW
Debug
Yes
No
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VB and LRECL=16384
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the IBM EREP Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
26:00
KEEP
any integer
26
REPORT
Yes
No
Yes

IBM SMF Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM SMF Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input type
File or directory (default)
Raw data input file or directory
any valid file or directory
FTP
Host
any valid host
Port
any valid port
21
User
any valid user
Password
any valid password
External file name
any valid file
Tape
Yes
No
No
RCMD
any valid site
SITE RDW
Debug
Yes
No
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VBS and LRECL=32760
Future data
Accept
Discard
Terminate
Discard
JES
JES2
JES3
JES2
Presummari-zation duration
any integer greater than or equal to 1 and less than or equal to 2,147,483,647
0
Use intermediate staging view
any valid staged table name
Duplicate-Data Checking Parameters for the IBM SMF Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
00:29
KEEP
any integer
52
REPORT
Yes
No
Yes

IBM TPF Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM TPF Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input type
File (default)
Raw data input file
any valid file
FTP
Host
any valid host
Port
any valid port
21
User
any valid user
Password
any valid password
External file name
any valid file
Tape
Yes
No
No
RCMD
any valid site
SITE RDW
Debug
Yes
No
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=S370VBS and LRECL=32760
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the IBM TPF Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:00
KEEP
any integer
26
REPORT
Yes
No
Yes

IBM VMMON Staging and Duplicate-Data Checking Parameters

Staging Parameters for the IBM VMMON Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input type
File (default)
Raw data input file
any valid file
FTP
Host
any valid host
Port
any valid port
21
User
any valid user
Password
any valid password
External file name
any valid file
Tape
Yes
No
No
RCMD
any valid site
SITE RDW
Debug
Yes
No
No
Input File Parameters
values for RECFM and LRECL parameters
RECFM=F and LRECL=4096
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the IBM VMMON Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
26:00
KEEP
any integer
26
REPORT
Yes
No
Yes

MS SCOM Staging and Duplicate-Data Checking Parameters

Staging Parameters for the MS SCOM Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input library: Library and Libref
any valid library and libref
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the MS SCOM Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:05
KEEP
any integer
52
REPORT
Yes
No
Yes

RRDtool Staging and Duplicate-Data Checking Parameters

Staging Parameters for the RRDtool Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input library or directory
any valid library or directory
rsh/ssh host command
rrdtool executable
rrdtool fetch -start option
e-2days
rrdtool fetch -end option
time
Consolidation Function (CF)
any consolidation function
AVERAGE
Class columns
any class columns
filename datetime
Normalize datetime
Yes
No
Yes
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the RRDtool Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
IDVAR
SAS variable
FILENAME
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:15
KEEP
any integer
52
REPORT
Yes
No
Yes

SAP ERP Staging and Duplicate-Data Checking Parameters

Staging Parameters for the SAP ERP Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input library: Library and Libref
any valid library and libref
Future data
Accept
Discard
Terminate
Discard
Presummarization duration
any integer greater than or equal to 1 and less than or equal to 2,147,483,647
3600
Duplicate-Data Checking Parameters for the SAP ERP Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
00:20
KEEP
any integer
250
REPORT
Yes
No
Yes

SAR Staging and Duplicate-Data Checking Parameters

Staging Parameters for the SAR Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input file or directory
any valid file or directory
Number of processors to use
any positive number
0, which means that all available processors are used
If 1, then MPConnect is not used and the staging code is run on a single processor.
Minimum number of files to read on each processor
any positive number
50
Temporary work space library
WORK library
Staging library
Other library
Library for temporary work space
any valid library
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the SAR Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:15
KEEP
any integer
52
REPORT
Yes
No
Yes

SNMP Staging and Duplicate-Data Checking Parameters

Staging Parameters for the SNMP Adapter
Parameters Supported for This Adapter
Values
Suboptions
Values for Suboptions
Default Values
Choose raw data input directory
any valid directory
rsh host command
any valid command
Use snmpwalk to gather character data
Yes
snmpwalk executable
any valid executable
HostFile for snmpwalk
any valid file
Community value for snmpwalk
any valid community name
No (default)
Choose access command
HP NNM/Netview (default)
snmpColDUmp
any valid executable
RRDtool
RRDtool executable
any valid executable
Number of days to load
a number from 1 to 365
2
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the SNMP Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
01:03
KEEP
any integer
52
REPORT
Yes
No
Yes

VMware Data Acquisition Parameters

Staging Parameters for the VMware Data Acquisition Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input library: Library and Libref
any valid library and libref
Age limit for data acquisition table (in days)
a positive integer
7
Note: The VMWare Data Acquisition adapter does not support duplicate-data checking parameters.

VMware vCenter Staging and Duplicate-Data Checking Parameters

Staging Parameters for the VMware vCenter Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input library: Library and Libref
any valid library and libref
Future data
Accept
Discard
Terminate
Discard
Duplicate-Data Checking Parameters for the VMware vCenter Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
00:18
KEEP
any integer
52
REPORT
Yes
No
Yes

Web Log Staging and Duplicate-Data Checking Parameters

Staging Parameters for the Web Log Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Raw data input file
any valid file
Delimiter in raw data
Space
Comma
Tab
Space
Future data
Accept
Discard
Terminate
Discard
Machine
any valid machine name
Site name
any valid site name
Presummarization duration
any integer greater than or equal to 1 and less than or equal to 2,147,483,647
3600
Duplicate-Data Checking Parameters for the Web Log Adapter
Parameters Supported for This Adapter
Values
Default Value
Notes
Enable duplicate checking
Yes
No
Yes
Duplicate checking options
Discard
Force
Terminate
Discard
INT
time in the format hh:mm, where hh represents hours and mm represents minutes
08:00
KEEP
any integer
250
REPORT
Yes
No
Yes