-- Licensed Materials - Property of IBM
-- IBM Cognos Products: ccllogging
-- (C) Copyright IBM Corp. 2013, 2014
-- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. 


CREATE TABLE COGIPF_MOBILESERVICE (
	COGIPF_HOST_IPADDR 		varchar (128) ,
	COGIPF_HOST_PORT 		integer ,
	COGIPF_PROC_ID 			integer ,
	COGIPF_LOCALTIMESTAMP 		timestamp ,
	COGIPF_TIMEZONE_OFFSET 		integer,
	COGIPF_SESSIONID 		varchar (255) ,
	COGIPF_REQUESTID 		varchar (255) not null ,
	COGIPF_STEPID 			varchar (255) ,
	COGIPF_SUBREQUESTID 	varchar (255) ,
	COGIPF_THREADID 		varchar (255) ,
	COGIPF_COMPONENTID 		varchar (64) ,
	COGIPF_BUILDNUMBER 		integer,
	COGIPF_LOG_LEVEL 		integer ,
	COGIPF_REPORT_TYPE 		varchar (255) ,
	COGIPF_REPORT_PATH 		varchar (512) ,
	COGIPF_STATUS 			varchar (255) ,
	COGIPF_ERRORDETAILS 	varchar (2000) ,
	COGIPF_EVENT_TYPE			varchar (255) ,
	COGIPF_REPORT_NAME 		varchar (255) ,	
	COGIPF_STORE_ID 		varchar (255) ,
	COGIPF_RUNTIME			integer ,
	COGIPF_DEVICE_ID		varchar (255) , 
	COGIPF_CLIENT_CATEGORY  	varchar (255) ,
	COGIPF_USER_AGENT 		varchar (512) ,
	COGIPF_USER_NAME		varchar (512) ,
	COGIPF_USER_UID		varchar (255) 
) IN IPFSCRIPT_CREATE_IN;

create index COGIPF_MOBILE_IDX on COGIPF_MOBILESERVICE (COGIPF_REQUESTID, COGIPF_USER_UID) USING STOGROUP IPFSCRIPT_STOGROUP;