tdCpu: tdCpu

In tranlm/tdR: Teradata interaction and query package

Description

Queries Teradata for CPU use. Can take a JDBC connection object (conn) if provided. If no JDBC connection is provided, then a connection is attempted using the user, and password provided. If none is provided, then tries to locate a connection object (conn) in the global environment.

If a connection profile (e.g. username, password, etc.) is provided, then an attempt is made to connect to Teradata. Once the query is run, the connection is then closed. If a connection object (conn) is provided to the function (or one is found globally), then the connection remains open.

Usage

tdCpu(user = "user", date = as.Date(Sys.time()), ...)

Arguments

user	Username to grab CPU use from. Defaults to the username used in the Teradata connection.
date	Date desired for query information. Defaults to today's date. If overwritten, can be in either the date format for R or the Teradata format YYMMDD.
...	Optional connection settings.

Value

A data.frame object is returned with the Teradata query information of the specified date.

See Also

tdConn for connection, tdDisk for disk usage, tdSpool for spool usage, and td for general queries

Examples

## NOT RUN ##
## Connect to default data warehouse and data base
# tdCpu(<username>, <password>)

## Runs query using a separately established connection
# conn = tdConn(<username>, <password>)
# tdCpu(conn=conn)

## Uses same connection, but allows code to find globally
# tdCpu()

tranlm/tdR documentation built on May 31, 2019, 7:45 p.m.