![]() ![]() Use the LOADCTL data set generated by DOMBLOD1 for the //SYSIN DD statement of the Db2 Load utility. This job runs the batch report specifying DB2LOAD and invokes the Db2 Load utility to load the table. For subsequent runs of a report, you can use the sample JCL provided in member #DOMLOAD of the hlq.llqSAMP data set (see Loading Apptune data into Db2 tables).If you change column names, you must make corresponding changes in the LOADCTL control statements. Use the DB2LOAD data generated by DOMBRPT1 and the LOADCTL control statements that are generated by DOMBLOD1 to load the table with data from the report.See the table in DB2LOAD statement and parameter for a list of the LOAD* reports. Duplicate column names cause an SQL error. Use the recommended LOAD* reports to avoid generating duplicate column names. You might want to change the column names to something more meaningful. The column names are taken from item names and formula numbers. Before defining the tables, check the column names generated by DOMBLOD1. ![]() Use the LOADDEF DDL that is generated by DOMBLOD1 to create the Db2 tables. LOADCTL DD DISP=(NEW,CATLG),DSN=?MYHLQ?.CTL, LOADDEF DD DISP=(NEW,CATLG),DSN=?MYHLQ?.DDL, DB2LOAD DD DISP=(SHR,PASS),DSN=&DB2LOAD * GENERATE THE DDL AND LOAD STMTS THAT CAN BE USED TO CREATE * SORT WORK FILES - ADJUST SIZE RELATIVE TO THE AMOUNT OF INPUT DATA UNIT=WORK, ** DD DUMMY, REPORT OUTPUT ** TRACEWRK DD DISP=(NEW,PASS), ** STAGED SORT OUTPUT. THE LOAD STATEMENTS ARE USED AS INPUT TO THE #DOMLOAD JOB. * CONSISTENT WITH ANY CHANGES YOU MAY HAVE HAD TO MAKE TO THE * YOU SHOULD ALSO REVIEW THE LOAD STATEMENTS TO VERIFY THEY ARE * YOU MUST EDIT THE DDL SO THAT ALL THE TABLES ARE CREATED IN THE * TABLE, YOU SHOULD REVIEW THE DDL TO DETERMINE IF MORE THAN ONE * AFTER THE DDL HAS BEEN GENERATED, YOU MUST USE THE DDL TO CREATE * STEP # 2: - GENERATE DDL AND LOAD STATEMENTS * ?DUNIT? = UNIT TYPE OF ?MYHLQ? DATA SET * ?MYHLQ? = HIGH LEVEL QUALIFIER OF DATA SET WHERE * ?TRACEDSN? = NAME OF DATA SET CONTAINING THE SMF, * LOAD307 : GENERATE APPTUNE IFCID 008-SQLOBJ * LOAD307 : GENERATE APPTUNE IFCID 307-SQLSTM * ?REPORT? = NAME OF AMFORDB2 REPORT TO RUN DOMLOAD JOB (ACCT),'DB2LOAD', CHANGE: ?BMC-HLQ? = AMFORDB2 HIGH LEVEL QUALIFIER LOADCTL-This data set contains Load utility control statements that are required to load the data into a table or tables.īoth output data sets have a fixed or fixed block record format with 80-byte records. LOADDEF-This data set contains the Data Definition Language (DDL) that is required to create the Db2 table or tables. The resulting output consists of two data sets: Input to DOMBLOD1 is the DB2LOAD data set written by DOMBRPT1. Run the DOMBLOD1 utility to produce the CREATE TABLE DDL and Load utility control statements for the tables.Run the DOMBRPT1 utility specifying the DB2LOAD parameter in the REPORT statement.Performance Advisor Database is a part of the following solutions: As an alternative, consider using the BMC Performance Advisor Database component. BMC plans to deprecate the PSSBLOAD utility and the usage of DB2LOAD DD statement for LOADxxx and other reports in the next release of Apptune. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |