Measurement Interval:

Measurement Interval in Throughput Test (Ts) = 13,066 seconds
Duration of Stream Execution:
Seed Query Start Date/Time Query End Date/Time RF1 Start Date/Time RF1 End Date/Time RF2 Start Date/Time RF2 End Date/Time Duration

Stream 00

625195613
06/26/03 00:32:32 06/26/03 01:16:34
06/26/03 00:31:30 06/26/03 00:32:32 06/26/03 01:17:30 06/26/03 04:47:29 06/26/03 04:48:03 06/26/03 04:49:17 06/26/03 04:49:50 06/26/03 04:51:04 06/26/03 04:51:37 06/26/03 04:52:54 06/26/03 04:53:28 06/26/03 04:54:46
06/26/03 01:16:34 06/26/03 01:17:08 06/26/03 04:47:29 06/26/03 04:48:03 06/26/03 04:49:17 06/26/03 04:49:50 06/26/03 04:51:04 06/26/03 04:51:37 06/26/03 04:52:54 06/26/03 04:53:28 06/26/03 04:54:46 06/26/03 04:55:19

0:44:36

Stream 01 Stream 02

625195614 625195615

06/26/03 01:17:33 06/26/03 04:44:06 06/26/03 01:17:33 06/26/03 04:46:18

3:30:30 3:32:17

Stream 03 Stream 04

625195618

06/26/03 01:17:33 06/26/03 04:44:52 06/26/03 01:17:33 06/26/03 04:45:21 06/26/03 01:17:33 06/26/03 04:46:23

3:34:04 3:35:55 3:37:46

Stream 05
MAXDATA PLATINUM TM 9000-4R with IBM DB2 UDB 8.1
TPC-H Timing Intervals (in seconds):
Query Stream 00 Stream 01 Stream 02 Stream 03 Stream 04 Stream 05 Minimum Average Maximum

Q1 229.6 1,179.8 977.1

Q2 19.0 56.4 83.0
Q3 16.1 47.4 76.1 28.9 71.0 89.8 28.9 62.6 89.8
Q4 14.5 75.8 27.6 94.2 114.6 124.4 27.6 87.3 124.4
Q5 72.6 209.6 186.7 386.7 516.0 280.9 186.7 316.0 516.0
Q6 12.4 96.2 52.6 40.9 54.3 40.8 40.8 57.0 96.2
Q7 81.7 492.6 548.1 486.7 394.5 412.5 394.5 466.9 548.1

Q8 65.1 205.3 207.6

Q9 273.7 833.3 880.4
Q10 47.1 248.7 334.1 246.9 467.3 230.0 230.0 305.4 467.3
Q11 20.9 208.4 171.3 128.8 107.8 164.5 107.8 156.2 208.4
Q12 19.9 92.7 98.8 49.8 257.3 259.8 49.8 151.7 259.8

775.8 104.1 853.6 57.6

235.6 1,427.3 160.5 1,598.3 295.4 160.5 644.5 644.5
2,148.9 174.3 775.8 1,187.0 56.4 95.1
220.9 1,076.8 295.4 1,598.3

2,148.9 174.3

Stream ID Stream 00 Stream 01 Stream 02 Stream 03 Stream 04 Stream 05 Minimum Average Maximum
Q13 Q14 Q15a 343.8 14.7 30.9 729.6 1,366.8 1,750.1 1,254.6 729.6 1,171.0 56.1 55.3 58.6 69.4 55.3 76.9 385.9 82.8 131.2 165.5 310.9 82.8 215.3 385.9
Q16 64.2 188.9 160.3 155.9 313.6 452.9 155.9 254.3 452.9

Q17 77.1

Q18 Q19 600.4 81.0

Q20 35.6

Q21 428.2

Q22 93.2

RF1 RF2 62.1 33.7 33.7 33.7 33.7 33.7 33.7 33.7 33.7 33.7
241.0 3,694.4 243.9 342.6 3,963.7 340.8 460.1 3,108.0 345.4 399.1 2,507.8 280.1 349.5 1,583.5 360.6 241.0 1,583.5 243.9 358.5 2,971.5 314.2 460.1 3,963.7 360.6
276.7 2,294.0 138.0 2,228.8 147.8 2,098.3 106.5 2,492.7 658.6 2,760.8 106.5 2,098.3 265.5 2,374.9 658.6 2,760.8

0x00000010-0x0000001F OK 0x00000022-0x0000002D OK 0x00000030-0x0000003F OK 0x00000044-0x0000005F OK 0x00000062-0x00000063 OK 0x00000065-0x0000006F OK 0x00000072-0x0000007F OK 0x00000080-0x00000080 OK 0x00000084-0x00000086 OK 0x00000088-0x00000088 OK 0x0000008C-0x0000008E OK 0x00000090-0x0000009F OK 0x000000A2-0x000000BD OK 0x000000E0-0x000000EF OK 0x00000CC0-0x00000CCF OK 0x000004D0-0x000004D1 OK 0x00000C00-0x00000C07 OK 0x00000020-0x00000021 controller OK 0x000000A0-0x000000A1 controller OK 0x00000081-0x00000083 controller OK 0x00000087-0x00000087 controller OK 0x00000089-0x0000008B controller OK 0x0000008F-0x0000008F controller OK 0x000000C0 -0x000000DF controller OK 0x00000040-0x00000043 0x00000070-0x00000071 clock OK 0x00000061-0x00000061 0x0000002E-0x0000002F OK 0x000003F0 -0x000003F5 controller OK 0x000003F7 -0x000003F7 controller OK 0x000003F8 -0x000003FF (COM1) OK 0x000002F8 -0x000002FF (COM2) OK 0x00000378-0x0000037F (LPT1) OK 0x00007000-0x00009FFF 0x00007000-0x00009FFF Interface to PCI Bridges
Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Motherboard resources Programmable interrupt Programmable interrupt Direct memory access Direct memory access Direct memory access Direct memory access Direct memory access System timer OK
System CMOS/real time System speaker OK
Motherboard resources Standard floppy disk Standard floppy disk Communications Port Communications Port Unsupported Printer Port PCI bus OK Intel(r) 82870 Hub OK
Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 45
0x00009000-0x00009FFF Interface to PCI Bridges 0x00009E00-0x00009EFF Fibre Channel Adapter 0x00009B00-0x00009BFF SCSI Host Adapter OK 0x00009D00-0x00009DFF SCSI Host Adapter OK 0x0000A000-0x0000CFFF 0x0000A000-0x0000CFFF Interface to PCI Bridges 0x0000AA00-0x0000AAFF Fibre Channel Adapter 0x0000AE00-0x0000AEFF Fibre Channel Adapter 0x0000B000-0x0000CFFF Interface to PCI Bridges 0x0000BA00-0x0000BAFF Fibre Channel Adapter 0x0000BE00-0x0000BEFF Fibre Channel Adapter 0x0000D000-0x0000EFFF 0x0000D000-0x0000EFFF Interface to PCI Bridges 0x0000DA00-0x0000DAFF Fibre Channel Adapter 0x0000DE00-0x0000DEFF Fibre Channel Adapter 0x0000E000-0x0000EFFF Interface to PCI Bridges 0x0000EA00-0x0000EAFF Fibre Channel Adapter 0x0000EE00-0x0000EEFF Fibre Channel Adapter [IRQs]
Intel(r) 82870 Hub OK QLogic QLA2200 PCI OK LSI Logic PCI-X Ultra320 LSI Logic PCI-X Ultra320 PCI bus OK Intel(r) 82870 Hub OK QLogic QLA23xx PCI OK QLogic QLA23xx PCI OK Intel(r) 82870 Hub OK QLogic QLA23xx PCI OK QLogic QLA23xx PCI OK PCI bus OK Intel(r) 82870 Hub OK QLogic QLA23xx PCI OK QLogic QLA23xx PCI OK Intel(r) 82870 Hub OK QLogic QLA23xx PCI OK QLogic QLA23xx PCI OK

Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 46
0xE5DF0000-0xE5DF0FFF Interrupt Controller OK 0xE5E00000-0xE5EFFFFF Interface to PCI Bridges 0xDFF00000-0xDFFFFFFF Interface to PCI Bridges 0xE5EE0000-0xE5EE0FFF Fibre Channel Adapter 0xE5EF0000-0xE5EF0FFF Fibre Channel Adapter 0xDFFF0000-0xDFFF00FF controller OK 0xE5DE0000-0xE5DE0FFF Interrupt Controller OK 0xE5F00000-0xE7FFFFFF Interface to PCI Bridges 0xE0000000-0xE4FFFFFF Interface to PCI Bridges 0xE5FE0000-0xE5FE0FFF Fibre Channel Adapter 0xE5FF0000-0xE5FF0FFF Fibre Channel Adapter 0xE4FF0000-0xE4FF00FF controller OK 0xDD000000-0xDEFFFFFF 0xFEC50000-0xFECFFFFF 0xDEDF0000-0xDEDF0FFF Interrupt Controller OK 0xDEE00000-0xDEEFFFFF Interface to PCI Bridges 0xDDE00000-0xDDEFFFFF Interface to PCI Bridges 0xDEEE0000-0xDEEE0FFF Fibre Channel Adapter 0xDEEF0000-0xDEEF0 FFF Fibre Channel Adapter 0xDDEF0000-0xDDEF00FF controller OK 0xDEDE0000-0xDEDE0FFF Interrupt Controller OK 0xDEF00000-0xDEFFFFFF Interface to PCI Bridges 0xDDF00000-0xDDFFFFFF Interface to PCI Bridges 0xDEFE0000-0xDEFE0FFF Fibre Channel Adapter 0xDEFF0000-0xDEFF0FFF Fibre Channel Adapter 0xDDFF0000-0xDDFF00FF controller OK [Components]
Intel(r) 82870 I/OxAPIC Intel(r) 82870 Hub OK Intel(r) 82870 Hub OK QLogic QLA23xx PCI OK QLogic QLA23xx PCI OK Intel(r) 82870 Hot Plug Intel(r) 82870 I/OxAPIC Intel(r) 82870 Hub OK Intel(r) 82870 Hub OK QLogic QLA23xx PCI OK QLogic QLA23xx PCI OK Intel(r) 82870 Hot Plug PCI bus OK PCI bus OK Intel(r) 82870 I/OxAPIC Intel(r) 82870 Hub OK Intel(r) 82870 Hub OK QLogic QLA23xx PCI OK QLogic QLA23xx PCI OK Intel(r) 82870 Hot Plug Intel(r) 82870 I/OxAPIC Intel(r) 82870 Hub OK Intel(r) 82870 Hub OK QLogic QLA23xx PCI OK QLogic QLA23xx PCI OK Intel(r) 82870 Hot Plug
c:\windows\system32\msadp32.acm Microsoft Corporation OK C:\WINDOWS\system32\MSADP32.ACM 5.2.3790.0 (srv03_rtm.030324-2048) 49.00 KB (50,176 bytes) 3/25/2003 5:00 AM c:\windows\system32\msgsm32.acm Microsoft Corporat ion OK C:\WINDOWS\system32\MSGSM32.ACM 5.2.3790.0 (srv03_rtm.030324-2048) 66.50 KB (68,096 bytes) 3/25/2003 5:00 AM c:\windows\system32\msg711.acm Microsoft Corporation OK C:\WINDOWS\system32\MSG711.ACM 5.2.3790.0 (srv03_rtm.030324-2048) 33.00 KB (33,792 bytes) 3/25/2003 5:00 AM c:\windows\system32\tssoft32.acm DSP GROUP, INC. OK C:\WINDOWS\system32\TSSOFT32.ACM 1.01 29.00 KB (29,696 bytes) 3/25/2003 5:00 AM [Video Codecs] CODEC Manufacturer Description Status File Version Size Creation Date c:\windows\system32\msrle32.dllMicrosoft Corporation OK C:\WINDOWS\system32\MSRLE32.DLL 5.2.3790.0 (srv03_rtm.030324-2048) 24.50 KB (25,088 bytes) 3/25/2003 5:00 AM c:\windows\system32\msvidc32.dll Microsoft Corporation OK C:\WINDOWS\system32\MSVIDC32.DLL 5.2.3790.0 (srv03_rtm.030324-2048) 67.00 KB (68,608 bytes) 3/25/2003 5:00 AM [CD-ROM] Item Value Drive Volume{fc7e9ce0-9c28-11d7 -b4ed806e6f6e6963} Description CD-ROM Drive Media Loaded No Media Type CD-ROM Name MATSHITA DVD-ROM SR-8176 Manufacturer (Standard CD-ROM drives) Status OK Transfer Rate Not Available SCSI Target ID 0 PNP Device ID IDE\CDROMMATSHITA_DVDROM_SR8176________________MZ31____\5&21C515B&0&0.0.0 Driver c:\windows\system32\drivers\cdrom.sys (5.2.3790.0 (srv03_rtm.030324-2048), 143.50 KB (146,944 bytes), 3/25/2003 5:00 AM) [Sound Device]

Size 17.09 GB (18,350,599,680 bytes) Total Cylinders 2,231 Total Sectors 35,841,015 Total Tracks 568,905 Tracks/Cylinder 255 Partition Disk #25, Partition #0 Partition Size 17.09 GB (18,350,567,424 bytes) Partition Starting Offset 32,256 bytes Description Disk drive Manufacturer (Standard disk drives) Model SEAGATE ST318452FC SCSI Disk Device Bytes/Sector 512 Media Loaded Yes Media Type Fixed hard disk Partitions 1 SCSI Bus 0 SCSI Logical Unit 0 SCSI Port 3 SCSI Target ID 12 Sectors/Track 63 Size 17.09 GB (18,350,599,680 bytes) Total Cylinders 2,231 Total Sectors 35,841,015 Total Tracks 568,905 Tracks/Cylinder 255 Partition Disk #26, Partition #0 Partition Size 17.09 GB (18,350,567,424 bytes) Partition Starting Offset 32,256 bytes Description Disk drive Manufacturer (Standard disk drives) Model SEAGATE ST318452FC SCSI Disk Device Bytes/Sector 512 Media Loaded Yes Media Type Fixed hard disk Partitions 1 SCSI Bus 0 SCSI Logical Unit 0 SCSI Port 3 SCSI Target ID 13 Sectors/Track 63 Size 17.09 GB (18,350,599,680 bytes) Total Cylinders 2,231 Total Sectors 35,841,015 Total Tracks 568,905 Tracks/Cylinder 255 Partition Disk #27, Partition #0 Partition Size 17.09 GB (18,350,567,424 bytes) Partition Starting Offset 32,256 bytes Description Disk drive Manufacturer (Standard disk drives) Model SEAGATE ST318452FC SCSI Disk Device Bytes/Sector 512 Media Loaded Yes Media Type Fixed hard disk Partitions 1 SCSI Bus 0 SCSI Logical Unit 0 SCSI Port 8 SCSI Target ID 0 Sectors/Track 63 Size 17.09 GB (18,350,599,680 bytes) Total Cylinders 2,231 Total Sectors 35,841,015 Total Tracks 568,905 Tracks/Cylinder 255 Partition Disk #84, Partition #0 Partition Size 17.09 GB (18,350,567,424 bytes)
Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 67
Description Disk drive Manuf acturer (Standard disk drives) Model SEAGATE ST318452FC SCSI Disk Device Bytes/Sector 512 Media Loaded Yes Media Type Fixed hard disk Partitions 1 SCSI Bus 0 SCSI Logical Unit 0 SCSI Port 8 SCSI Target ID 1 Sectors/Track 63 Size 17.09 GB (18,350,599,680 bytes) Total Cylinders 2,231 Total Sectors 35,841,015 Total Tracks 568,905 Tracks/Cylinder 255 Partition Disk #85, Partition #0 Partition Size 17.09 GB (18,350,567,424 bytes) Partition Starting Offset 32,256 bytes Description Disk drive Manufacturer (Standard disk drives) Model SEAGATE ST318452FC SCSI Disk Device Bytes/Sector 512 Media Loaded Yes Media Type Fixed hard disk Partitions 1 SCSI Bus 0 SCSI Logical Unit 0 SCSI Port 8 SCSI Target ID 2 Sectors/Track 63 Size 17.09 GB (18,350,599,680 bytes) Total Cylinders 2,231 Total Sectors 35,841,015 Total Tracks 568,905 Tracks/Cylinder 255 Partition Disk #86, Partition #0 Partition Size 17.09 GB (18,350,567,424 bytes) Partition Starting Offset 32,256 bytes Description Disk drive Manufacturer (Standard disk drives) Model SEAGATE ST318452FC SCSI Disk Device Bytes/Sector 512 Media Loaded Yes Media Type Fixed hard disk Partitions 1 SCSI Bus 0 SCSI Logical Unit 0 SCSI Port 8 SCSI Target ID 3 Sectors/Track 63 Size 17.09 GB (18,350,599,680 bytes) Total Cylinders 2,231 Total Sectors 35,841,015 Total Tracks 568,905 Tracks/Cylinder 255 Partition Disk #87, Partition #0 Partition Size 17.09 GB (18,350,567,424 bytes) Partition Starting Offset 32,256 bytes Description Disk drive Manufacturer (Standard disk drives) Model SEAGATE ST318452FC SCSI Disk Device Bytes/Sector 512 Media Loaded Yes

mshtml 6.00.3790.0 (srv03_rtm.030324-2048) 7.83 MB (8,208,384 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\mshtml.dll msimtf 5.2.3790.0 (srv03_rtm.030324-2048) 528.00 KB (540,672 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\msimtf.dll msctf 5.2.3790.0 (srv03_rtm.030324-2048) 924.50 KB (946,688 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\msctf.dll jscript 5.6.0.8515 1.21 MB (1,268,736 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\jscript.dll msls31 3.10.349.0 448.00 KB (458,752 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\msls31.dll imm32 5.2.3790.0 (srv03_rtm.030324-2048) 307.50 KB (314,880 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\imm32.dll mshtmled 6.00.3790.0 (srv03_rtm.030324-2048) 1.34 MB (1,408,512 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\mshtmled.dll vbscript 5.6.0.8515 1.06 MB (1,110,016 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\vbscript.dll mfc42 6.00.3014.0 3.36 MB (3,526,656 bytes) 3/25/2003 5:00 AM Microsoft Corporation c:\windows\system32\mfc42.dll msinfo 5.2.3790.0 (srv03_rtm.030324-2048) 1.20 MB (1,257,984 bytes) 6/11/2003 5:03 PM Microsoft Corporation c:\windows\pchealth\helpctr\binaries\msinfo.dll helpsvc 5.2.3790.0 (srv03_rtm.030324-2048) 2.18 MB (2,289,152 bytes) 6/11/2003 5:03 PM Microsoft Corporation c:\windows\pchealth\helpctr\binaries\helpsvc.exe
Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 108
d:\sqllib\bin\db2sec.exe Normal LocalSystem 0 DB2 - DB2QUAL-0 DB2QUAL-0 Running Manual Own Process d:\sqllib\bin\db2syscs.exe Normal.\db2qual 0 DB2 - DB2QUAL-1 DB2QUAL-1 Running Manual Own Process d:\sqllib\bin\db2syscs.exe Normal.\db2qual 0 DB2 Remote Command Server DB2REMOTECMD Running Auto Own Process d:\sqllib\bin\db2rcmd.exe Ignore.\db2tpch 0 DB2 - DB2TPCH-0 DB2TPCH-0 Stopped Manual Own Process d:\sqllib\bin\db2syscs.exe Normal.\db2tpch 0 DB2 - DB2TPCH-1 DB2TPCH-1 Stopped Manual Own Process d:\sqllib\bin\db2syscs.exe Normal.\db2tpch 0 DB2 - DB2TPCH-2 DB2TPCH-2 Stopped Manual Own Process d:\sqllib\bin\db2syscs.exe Normal.\db2tpch 0 DB2 - DB2TPCH-3 DB2TPCH-3 Stopped Manual Own Process d:\sqllib\bin\db2syscs.exe Normal.\db2tpch 0 Distributed File System Dfs Stopped Manual Own Process c:\windows\system32\dfssvc.exe Normal LocalSystem 0 DHCP Client Dhcp Running Auto Share Process c:\windows\system32\svchost.exe -k networkservice Normal NT AUTHORITY\NetworkService 0 Logical Disk Manager Administrative Service dmadmin Running Auto Share Process c:\windows\system32\dmadmin.exe /com Normal LocalSystem 0 Logical Disk Managerdmserver Running Auto Share Process c:\windows\system32\svchost.exe -k netsvcs Normal LocalSystem 0 DNS Client Dnscache Running Auto Share Process c:\windows\system32\svchost.exe -k net workservice Normal NT AUTHORITY\NetworkService 0 Error Reporting Service ERSvc Running Auto Share Process c:\windows\system32\svchost.exe -k winerr Ignore LocalSystem 0 Event Log Eventlog Running Auto Share Process c:\windows\system32\services.exe Normal LocalSystem 0 COM+ Event System EventSystem Running Manual Share Process c:\windows\system32\svchost.exe -k netsvcs Normal LocalSystem 0 Help and Support helpsvc Running Auto Share Process c:\windows\system32\svchost.exe -k netsvcs Normal LocalSystem 0 Human Interface Device Access HidServ Stopped Disabled Share Process

Page Refresh Type Automatic Temporary Internet Files Folder C:\Documents and Settings\NetworkService\Local Settings\Temporary Internet Files Total Disk Space Not Available Available Disk Space Not Available Maximum Cache Size Not Available Available Cache Size Not Available [List of Objects] Program File Status CodeBase No cached object information available [Content] [ Following are sub-categories of this main category ] [Summary] Item Value Content Advisor Disabled
[Personal Certificates] Issued To Issued By Validity Signature Algorithm No personal certificate information available [Other People Certificates]
Item Value Connection Preference LAN Settings

Never dial

Issued To Issued By Validity Signature Algorithm No other people certificate information available [Publishers] Name No publisher information available [Security] Zone Security Level My Computer Custom Local intranet Medium-low Trusted sites Low Internet Medium Restricted sites High
AutoConfigProxy Not Available AutoProxyDetectMode Disabled AutoConfigURL http://autoproxy Proxy Enabled ProxyServer proxy.ch.intel.com:1022 ProxyOverride <local> [Cache] [ Following are sub-categories of this main category ] [Summary] Item Value
Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 113
Appendix B: Database Build Scripts

Buildtpcd

#!/usr/bin/perl # usage buildtpcd [QUAL] # ASSUMPTIONS: all ddl files have commits in them! ($myName = $0) =~ s@.*/@@; $usage=" Usage: buildtpcd [QUAL] where QUAL is the optional parameter saying to build the qualification database (sf =.1 = 100MB)\n"; $qual=""; if (@ARGV == 1) { $qual = $ARGV[0]; } # get TPC-D specific environment variables require 'getvars'; # Use the macros in here so that they can handle the platform differences. # macro.pl should be sourced from cmvc, other people wrote and maintain it. require "macro.pl" ; require "tpcdmacro.pl"; # Make output unbuffered. select(STDOUT); $| = 1 ; # verify that necessary environment variables for building the database # are present. Default those that aren't necessary require "version"; $instance=$ENV{"DB2INSTANCE"}; if (length($ENV{"TPCD_PLATFORM"}) <= 0) { die "TPCD_PLATFORM environment variable not set \n"; } $platform=$ENV{"TPCD_PLATFORM"}; if ( $platform eq "nt" ) { $sep="&"; } else { $sep=";"; } if ((length($ENV{"TPCD_BUILD_STAGE"}) <= 0) || ($ENV{"TPCD_BUILD_STAGE"}) eq "NULL" ) { $ENV{"TPCD_BUILD_STAGE"} = "ALL"; } if (length($ENV{"TPCD_PRODUCT"}) <= 0) { die "Must set TPCD_PRODUCT env't var.\n"; } if ( length($ENV{"TPCD_DBNAME"}) <= 0 ) { die "TPCD_DBNAME environment variable not set\n"; } if (length($ENV{"TPCD_MODE"}) <= 0) { die "TPCD_MODE environment variable not set uni/smp/mln \n"; } if (length($ENV{"TPCD_SF"}) <= 0) { die "TPCD_SF environment variable not set \n"; } if (length($ENV{"TPCD_DBPATH"}) <= 1) { # if no db pathname specified, build the db in the home directory if ( $platform eq "aix" || $platform eq "sun" || $platform eq "ptx" || $platform eq "hp") { $ENV{"TPCD_DBPATH"} = $ENV{"HOME"}; } elsif ( $platform eq "nt" ) { $ENV{"TPCD_DBPATH"} = $ENV{"HOMEDRIVE"}; } else { die "platform $platform not supported yet \n"; } } if (length($ENV{"TPCD_DDLPATH"}) <= 0) { # if no db pathname specified, use default $ENV{"TPCD_DBPATH"} = "/afs/tor/groups/dbp/perf/benchmark/tpcd/ddl/vanilla"; } if (length($ENV{"TPCD_GENERATE_SEED_FILE"}) <= 0) { # if no db pathname specified, use default $ENV{"TPCD_GENERATE_SEED_FILE"} = "no"; } if (length($ENV{"TPCD_DDL"}) <= 0) { $ENV{"TPCD_DDL"} = "dss.ddl"; } if (length($ENV{"TPCD_STAGING_TABL E_DDL"}) <= 0) { $ENV{"TPCD_STAGING_TABLE_DDL"} = "NULL"; } if (length($ENV{"TPCD_PRELOAD_STAGING_TABLE_SC RIPT"}) <= 0) { $ENV{"TPCD_PRELOAD_STAGING_TABLE_DDL"} = "NULL"; } if (length($ENV{"TPCD_DELETE_STAGING_TABLE_SQL "}) <= 0) { $ENV{"TPCD_DELETE_STAGING_TABLE_DDL"} = "NULL"; } if (length($ENV{"TPCD_TBSP_DDL"}) <= 0) { $ENV{"TPCD_TBSP_DDL"} = "dss.tbsp.ddl";

Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 118
if ( $fparse eq "yes" ) { print " FASTPARSE used on load\n"; } } if ( $loadscript ne "NULL") { print " Load commands in $ddlpath${delim}$loadscript\n"; } print " Degree of parallelism (dft_degree and max_querydegree) set to $smpdegree\n"; if ( $agentpri ne "NULL" ) { print " AGENTPRI set to $agentpri\n"; } if ( $activate eq "yes" ) { print " Database will be activated when build is complete\n"; } if ( $explainDDL ne "NULL" ) { print " EXPLAIN DDL being used from $ddlpath${delim}$explainDDL\n"; } else { print " EXPLAIN DDL being used from default sqllib directory\n"; } print "Sleeping for 15 seconds to give you a chance to reconsider.\n"; sleep 15; # getc(); # don't need separate calls for mln/mpp vs uni since the $all_ln will be # defined appropriately if ( $platform eq "nt" ) { if (($mode eq "uni") || ($mode eq "smp")) { #spaces required for NT $rc=&dodb_noconn("db2set DB2OPTIONS=\" -t -v +c\"",$all_ln); } else { $rc=&dodb_noconn("db2set DB2OPTIONS=\\\" -t -v +c\\\"",$all_ln); } } else { if (($mode eq "uni") || ($mode eq "smp")) { $rc=&dodb_noconn("db2set DB2OPTIONS=\"-t -v +c\"",$all_ln); } else { $rc=&dodb_noconn("db2set DB2OPTIONS=\\\"-t -v +c\\\"",$all_ln); } }
if ( $rc != 0 ) { die "failure setting db2 environment variable : DB2OPTIONS rc=$rc\n"; } if ( $platform eq "nt" ) { $rc=&dodb_noconn("db2set DB2NTNOCACHE=ON",$all_ln); } if ( $ret != 0 ) { die "failure setting db2 environment variable : DB2NTNOCACHE\n"; } # @de980723wlc # set the db2 env vars for loading, from the TPCD_LOAD_DB2SET_SCRIPT script if ( $loadsetScript ne "NULL" ) { if ( $platform eq "nt" ) { #### Mike , th, the- for some reason rah on NT doesn't like running #### a fully qualified file name. Switch to dir, then run ## check CHANGE THIS to have single node and multinode execution if (( $mode eq "uni" ) || ( $mode eq "smp" )) { $ret=system("${ddlpath}${delim}$loadsetScript"); #$ret=system("cd ${ddlpath} $sep $loadsetScript"); } else { $ret=system("db2_all \"call ${ddlpath}${delim}$loadsetScript\" "); } } else { $ret=system("${ddlpath}${delim}$loadsetScript"); } if ( $ret != 0 ) { die "failure setting load time db2set parms from $loadsetScript \n"; } } # stopping and starting db2 before we continue print "Stopping DB2.\n"; $rc=system("db2stop"); if ( $rc < 0 ) { die "failure during db2stop rc = $rc \n"; } print "Starting DB2.\n"; $rc=system("db2start"); if ( $rc != 0 ) { die "failure during db2start rc = $rc \n"; } # create the database if ( $buildStage eq "ALL" ) { # build from the beginning &outtime("*** Starting to create the database");

if ( $qual ne "QUAL" ) { if ( $preloadSampleUF ne "NULL" ) { # preload the sample UF data for statistics gathering $rc = system ("perl $ddlpath${delim}$preloadSampleUF"); } if ( $deleteSampleUF ne "NULL" ) { # delete the sample rows now that stats have been gathered &dodb2file($dbname,"$ddlpath${delim}$deleteSampleUF", $once); } } } &dodb2file($dbname,"$ddlpath${delim}$ddl",$once); # update the locksize on the non-updated tables to be table level locking # update the tables for appendmode if ($appendOn eq "yes") { &dodb_conn($dbname, "db2 alter table tpcd.nation locksize table $sep \ db2 alter table tpcd.region locksize table $sep \ db2 alter table tpcd.customer locksize table $sep \ db2 alter table tpcd.supplier locksize table $sep \ db2 alter table tpcd.part locksize table $sep \ db2 alter table tpcd.partsupp locksize table $sep \ db2 alter table tpcd.lineitem append on $sep \ db2 alter table tpcd.orders append on", $once); } else { &dodb_conn($dbname, "db2 alter table tpcd.nation locksize table $sep \ db2 alter table tpcd.region locksize table $sep \ db2 alter table tpcd.customer locksize table $sep \ db2 alter table tpcd.supplier locksize table $sep \ db2 alter table tpcd.part locksize table $sep \ db2 alter table tpcd.partsupp locksize table", $once); } if ( $mode eq "mpp" ) { #need parallel specific print "need to figure parallel specific creation of tmp\n";
Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 121
} mkdir("${delim}tmp${delim}$instance",0777); } # end of "CREATE TABLESPACE and TABLES" phase if (( $buildStage eq "ALL" ) || ( $buildStage eq "CRTTBSP" ) || ( $buildStage eq "LOAD" ) || (($buildStage eq "INDEX" ) && ( $earlyindex eq "yes" )) ) { # do the load stage of the build, or if early index is on do # the index creation also # setup the load configuration if ( $buildStage ne "ALL") { # we're restarting a build so reapply the load config &outtime("*** Setting LOAD configuration."); if (($loadconfigfile eq "") || ($loadconfigfile eq "NULL")) { &dodb_noconn("db2 update db cfg for $dbname using buffpage $buffpage $sep \ db2 update db cfg for $dbname using sortheap $sortheap $sep \ db2 update db cfg for $dbname using num_iocleaners $ioclnrs $sep \ db2 update db cfg for $dbname using num_ioservers $ioservers $sep \ db2 update db cfg for $dbname using util_heap_sz $util_heap_sz $sep \ db2 update db cfg for $dbname using chngpgs_thresh $chngpgs", $all_ln); &dodb_noconn("db2 update dbm cfg using sheapthres $sheapthres",$once); } else { &dodb2file_noconn("$ddlpath${delim}$loadconfigfile",$all _ln); &dodb2file_noconn("$ddlpath${delim}$loadDBMconfig",$o nce); } &dodb_noconn("db2 terminate",$once); $rc=system("db2stop"); if ( $rc != 0 ) { die "failure during db2stop after resetting for load config rc = $rc \n"; } $rc=system("db2start"); if ( $rc != 0 ) { die "failure during db2start rc = $rc \n"; } }

system("db2start"); &dodb_conn($dbname,"db2 \"update db cfg for tpcd using util_heap_sz 200000\"",$all_ln); system("db2stop"); &outtime("*** Starting the backup"); $rc = system("backup_tpcd.bat"); # ($rc == 0) | die "Test database backup failed, rc = $rc.\n"; &outtime("*** Finished the backup"); system("db2start"); &dodb_conn($dbname,"db2 \"update db cfg for tpcd using util_heap_sz 40000\"",$all_ln); } } # stop and restart the database to get config parms recognized $rc=system("db2stop"); #if ( $rc != 0 ) #{ # die "failure during db2stop rc = $rc \n"; #} $rc=system("db2start"); if ( $rc != 0 ) { die "failure during db2start rc = $rc \n"; } &outtime("*** Set Configuration completed"); &outtime("*** End of audited Load Time"); #create generated seeds if ( $genSeed ne "no" ) { $rc = system("perl createmseedme.pl 1000"); if ( $rc != 0 ) { warn "createmseedme failed\n"; } } $rc = system("perl buildtpcdbatch $qual"); if ( $rc != 0 ) { die "buildtpcdbatch failed rc=$rc\n"; } if ( $RealAudit eq "yes" ) { # if we are in real audit mode then we have to do a number of things # set up the audit directory structure and the run directory structure # so that once we have completed the buildtpcd, we are ready to run. # first remove any old "update pair number" file so we won't get prompted # doing setupDir &rm("$auditDir${delim}tools${delim}tpcd.runsetup"); system("perl setupRun"); # before we stop the database for the final time # if we are in the real audit mode then run dbtables and dbcheck before # we print out the final notice that we are ready to run the performance tests # if we are building the qualification database then we will bind to both # the dbname database and the qualification database if ( $qual eq "QUAL" )
Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 125
{ $verifyType="q"; } else { $verifyType="t"; } system("perl tablesdb $verifyType"); &dodb2file($dbname,"$auditDir${delim}tools${delim}first1 0rows.sql",$once); } # stop, restart and activate the database, if necessary #Create Catalog info $rc = system("perl catinfo.pl b"); if ( $rc != 0 ) { warn "catinfo failed!!! rc = $rc\n"; } $rc=system("db2stop"); if ( $rc != 0 ) { die "failure during db2stop rc = $rc \n"; } &outtime("*** Ready to run the performance tests once the dbm has restarted"); if ( $RealAudit ne "yes" ) { # if we are not in a real audit, then we can restart the database manager # if we are in a real audit, then we don't want to do this until the # power test starts $rc=system("db2st art"); if ( $rc != 0 ) { die "failure during db2start rc = $rc \n"; } if ( $activate eq "yes" ) { &dodb_noconn("activate database $dbname",$once); } } # finished creating the database &outtime("*** Finished creating the database"); 1;

Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 152
Number of rows retrieved is: 7 --------------------------------------------Stop timestamp 06/27/03 16:56:29.640 Query Time = 2.7 secs
SELECT * FROM TPCD.PART FETCH FIRST 10 ROWS ONLY P_PARTKEY P_NAME P_MFGR P_BRAND P_TYPE P_SIZE P_CONTAINER P_RETAILPRICE P_COMMENT ----------- ------------------------------------------------------- ------------------------ ---------- ------------------------- ----------- ---------- ------------------------ ----------------------10 floral moccasin royal powder burnished Manufacturer#5 Brand#54 LARGE BURNISHED STEEL 44 LG CAN +9.10010000000000E+002 bold, ironic 11 chocolate turquoise sandy snow misty Manufacturer#2 Brand#25 STANDARD BURNISHED NICKEL 43 WRAP BOX +9.11010000000000E+002 furiousl 14 linen seashell burnished blue gainsboro Manufacturer#1 Brand#13 SMALL POLISHED STEEL 28 JUMBO BOX +9.14010000000000E+002 special, regular 37 turquoise ivory orange sandy maroon Manufacturer#4 Brand#45 LARGE POLISHED TIN 48 JUMBO BOX +9.37030000000000E+002 blithely regular 39 rose dodger lace peru floral Manufacturer#5 Brand#53 SMALL POLISHED TIN 43 JUMBO JAR +9.39030000000000E+002 quickly bo 43 medium khaki chocolate rosy blush Manufacturer#4 Brand#44 PROMO POLISHED STEEL 5 WRAP CASE +9.43040000000000E+002 carefully iro 47 sky firebrick red linen dim Manufacturer#4 Brand#45 LARGE BURNISHED BRASS 14 JUMBO PACK +9.47040000000000E+002 bold, unusual a 49 blue tan cornsilk burlywood beige Manufacturer#2 Brand#24 SMALL BURNISHED TIN 31 MED DRUM +9.49040000000000E+002 carefu 50 yellow cornflower royal blush almond Manufacturer#3 Brand#33 LARGE ANODIZED TIN 25 WRAP PKG +9.50050000000000E+002 regular dinos ar 55 antique cream pale tomato rose Manufacturer#2 Brand#23 ECONOMY BRUSHED COPPER 9 MED BAG +9.55050000000000E+002 furiously 10 record(s) selected. SELECT * FROM TPCD.SUPPLIER FETCH FIRST 10 ROWS ONLY S_SUPPKEY S_NAME S_ADDRESS S_NATIONKEY S_PHONE S_ACCTBAL S_COMMENT ----------- ------------------------- --------------------------------------- ----------- --------------- ------------------------ --------------------------------------------------------------------------------------------------10 Supplier#000000010 Saygah3gYWMp72i PY 24 34-852-489-8585 +3.89191000000000E+003 ironic deposits poach quickly furiously final accounts. carefull 49 Supplier#000000049 Nvq 6macF4GtJvz 24 34-211-567-6800 +9.91524000000000E+003 blithely silent pinto beans hang slyly. blithely eve

Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 177
return TPCDBATCH_NONSELECT; } /** If you go through a file with just comments or control statments with no SQL, there's nothing to process.Exit TPCDBATCH **/ else return TPCDBATCH_NONSQL; } /* Get_SQL_stmt */ /* @d23684 tjg */
/************************************************ *******************/ /* allocate_sqlda -- This routine allocates space for the SQLDA. */ /************************************************ *******************/ void allocate_sqlda(struct sqlda *sqlda) { int loopvar; /* Loop counter */ for (loopvar=0; loopvar<sqlda->sqld; loopvar++) { switch (sqlda->sqlvar[loopvar].sqltype) { case SQL_TYP_INTEGER: /* INTEGER */ case SQL_TYP_NINTEGER: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)malloc(sizeof(sqlint32))) == NULL) mem_error("allocating INTEGER"); break; case SQL_TYP_BIGINT: /* BIGINT */ /*kmwBIGINT*/ case SQL_TYP_NBIGINT: /*#ifdef SQLWINT */ /* if ((sqlda->sqlvar[loopvar].sqldata= */ /* (TPCDBATCH_CHAR *)malloc(sizeof(__int64))) == NULL)*/ /* #else */ if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)malloc(sizeof(sqlint64))) == NULL) /* #endif*/ mem_error("allocating BIGINT"); break; case SQL_TYP_CHAR: /* CHAR */ case SQL_TYP_NCHAR: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)calloc(256,sizeof(char))) == NULL) mem_error("allocating CHAR/VARCHAR"); break; case SQL_TYP_VARCHAR: /* VARCHAR */ case SQL_TYP_NVARCHAR: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)calloc(4002,sizeof(char))) == NULL) mem_error("allocating CHAR/VARCHAR"); break; case SQL_TYP_LONG: /* LONG VARCHAR */ case SQL_TYP_NLONG:
if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)calloc(32702,sizeof(char))) == NULL) mem_error("allocating VARCHAR/LONG VARCHAR"); break; case SQL_TYP_FLOAT: /* FLOAT */ case SQL_TYP_NFLOAT: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)malloc(sizeof(double))) == NULL) mem_error("allocating FLOAT"); break; case SQL_TYP_SMALL: /* SMALLINT */ case SQL_TYP_NSMALL: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)malloc(sizeof(short))) == NULL) mem_error("allocating SMALLINT"); break; case SQL_TYP_DECIMAL: /* DECIMAL */ case SQL_TYP_NDECIMAL: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)malloc(20)) == NULL) mem_error("allocating DECIMAL"); break; case SQL_TYP_CSTR: /* VARCHAR (null terminated) */ case SQL_TYP_NCSTR: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)calloc(4001,sizeof(char))) == NULL) mem_error("allocating CHAR/VARCHAR"); break; case SQL_TYP_DATE: /* DATE */ case SQL_TYP_NDATE: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)calloc(13,sizeof(char))) == NULL) mem_error("allocating DATE"); break; case SQL_TYP_TIME: /* TIME */ case SQL_TYP_NTIME: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)calloc(11,sizeof(char))) == NULL) mem_error("allocating TIME"); break; case SQL_TYP_STAMP: /* TIMESTAMP */ case SQL_TYP_NSTAMP: if ((sqlda->sqlvar[loopvar].sqldata= (TPCDBATCH_CHAR *)calloc(29,sizeof(char))) == NULL) mem_error("allocating TIMESTAMP"); break; } if ((sqlda->sqlvar[loopvar].sqlind= (short *)calloc(1,sizeof(short))) == NULL) mem_error("allocating indicator"); } sqlda_allocated = 1; /* fix free() problem on NT wlc 090597 */ return; /* allocate_sqlda */ }

Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 196
T_STAMP_3LEN,T_STAMP_3LEN, /* TIME_ACC jen*/ g_struct->s_info_ptr->start_stamp); if (g_struct ->c_l_opt->intStreamNum >= 0) { if (g_struct->lSeed == -1) { fprintf( outstream,"Using default qgen seed file"); } else fprintf( outstream,"Seed used = %ld",g_struct>lSeed); fprintf( outstream,"\n"); } } if (g_struct ->c_l_opt->update < 4){ /* run only if updates are enabled */ runUF2(g_struct, currentUpdatePair); if (g_struct ->c_l_opt->intStreamNum == 0) {/* RUNPOWER */ fprintf(stderr, "UF2 completed\n"); } } currentUpdatePair += 1; /* update the update.pair.num file to reflect the successfully completed */ /* update pair */ if (g_struct ->c_l_opt->update < 4) { /*jen*/ #ifndef NO_INCREMENT /* don't update the pair, only for my testing - Haider */ updateFP = fopen(g_struct->update_num_file,"w"); fprintf(updateFP,"%d\n",currentUpdatePair); fclose(updateFP); #endif } /*jen*/ rc = FALSE; break; } return(rc); } /************************************************ *********************/ /* Handles actual processing of SQL statement. Initializes the SQLDA for returned rows, does PREPARE, DECLARE, and OPEN statements and executed multiple FETCHes as needed. If not a SELECT statement, goes into EXECUTE IMMEDIATE section */ /************************************************ *********************/ void SQLprocess(struct global_struct *g_struct) { int rc = 0; /* 912RETRY */ int rows_fetch = 0; long sqlcode = SQL_RC_E911; /* Temporary sqlcode to test for deadlocks */ int max_wait = 1; /* Maximum number of retries for deadlock scenario */ int col_lengths[TPCDBATCH_MAX_COLS]; /* array containing widths of columns in returned set */
struct stmt_info *s_info_ptr; s_info_ptr = g_struct->s_info_ptr; /************************************************ ***********************/ /* grab storage for the SQLDA */ /************************************************ ***********************/ if ((sqlda=(struct sqlda *)malloc(SQLDASIZE(100))) == NULL) mem_error("allocating sqlda"); sqlda->sqln = TPCDBATCH_MAX_COLS; /* @d30369 tjg */ /* Error-recovery code for errors resulting from multistream errors */ while (((sqlcode == SQL_RC_E911) || (sqlcode == SQL_RC_E912) || (sqlcode == SQL_RC_E901)) && (max_wait < MAXWAIT) && (rc==0) ) { sqlcode = 0; /* Re-initialize sqlcode to avoid infinite-loop */ if (g_struct ->c_flags->select_status == TPCDBATCH_SELECT) { /* Enter this loop if SQL stmt is a SELECT */ EXEC SQL PREPARE STMT1 INTO :*sqlda FROM :stmt_str; sqlcode = error_check(); if (sqlcode < 0) { fprintf (stderr,"\nPrepare failed. Stopping this query.\n"); rc = -1; } else /* print out the column headings for the answer set */ { print_headings(sqlda,col_lengths); /* @d22817 tjg */ allocate_sqlda(sqlda); /* This is where we set storage for the */ /* SQLDA based on the column types in */ /* the answer set table. */ EXEC SQL DECLARE DYNCUR CURSOR FOR STMT1; EXEC SQL OPEN DYNCUR; sqlcode = error_check(); if (sqlcode < 0) /* we ran into an error of some kind KBS 98/09/28 */ { max_wait ++; fprintf (stderr, "\nAn error has been detected on open.Retrying.\n"); SleepSome(10); } else {

Copyright MAXDATA Computer AG 2003. All rights reserved. TPC Benchmark H Full Disclosure Report July 2003 215
rc = 0; goto Texit; Terror: EXEC SQL CLOSE L_CURSOR; EXEC SQL CLOSE O_CURSOR; EXEC SQL rollback work; if (sqlca.sqlcode != 0) sqlerror("acidT: ROLLBACK FAILED", &sqlca); T exit: if (acid->logging) { fprintf(out,"\n---------- END of acidT tag: %d ---------\n\n",mypid); fflush(out);fclose(out); } return(rc); } /*--------------------------------------------------------------*/ /* updateQ */ /*--------------------------------------------------------------*/ int updateQ (struct update_struct *us) { FILE *out; time_t timeT; struct timeval tv; struct timezone tz; int qnum; int rc = 0; int i; int secs2sleep; char buff[256]; struct acidtype {int logging;} a, *acid; EXEC SQL BEGIN DECLARE SECTION; double acctbal; double discount; double price; sqlint32 availqty; sqlint32 size; EXEC SQL END DECLARE SECTION; qnum = us->qnum; acid = &a; acid->logging= 1; sprintf(buff, "%s%cupdate.out",getenv("TPCD_TMP_DIR"),del()); out=fopen(buff,"a"); gettimeofday(&tv, &tz); time(&timeT); fprintf(out,"\n---------- START of update ----------\n\n"); fprintf(out, "update query number: %d, begin transaction time: (%us %06uu) %s", qnum, tv.tv_sec, tv.tv_usec, ctime(&timeT)); sqlca.sqlcode = 0; discount = 0.25; price = 5000.50; acctbal = 1000.00; availqty = 10; size = 5; for (i=1; i <= 2; i++) { gettimeofday(&tv, &tz); time(&timeT);
fprintf(out,"update query number: %d, pass %d, immediately before UPDATE: (%us %06uu) %s", qnum, i, tv.tv_sec, tv.tv_usec, ctime(&timeT)); switch (qnum) { case 1: { EXEC SQL UPDATE TPCD.LINEITEM set L_DISCOUNT = L_DISCOUNT + :discount WHERE L_ORDERKEY IN (326,512,928,995); if (sqlca.sqlcode != 0) { rc = sqlca.sqlcode; if (acid->logging) { fprintf(out,"update query number: %d, pass %d, **ERROR** sqlcode = %d\n", qnum, i, sqlca.sqlcode); } else { fprintf(stderr,"update query number: %d, pass %d, **ERROR** sqlcode = %d\n", qnum, i, sqlca.sqlcode); } sqlerror("update query number 1", &sqlca); goto Uerror; } discount = discount * (-1); secs2sleep = 300; break; } case 2: { EXEC SQL UPDATE TPCD.SUPPLIER set S_ACCTBAL = S_ACCTBAL + :acctbal WHERE S_NAME in ('Supplier#000000647','Supplier#000000070','Supplier#0000 00802'); if (sqlca.sqlcode != 0) { rc = sqlca.sqlcode; if (acid->logging) { fprintf(out,"update query number: %d, pass %d, **ERROR** sqlcode = %d\n", qnum, i, sqlca.sqlcode); } else { fprintf(stderr,"update query number: %d, pass %d, **ERROR** sqlcode = %d\n", qnum, i, sqlca.sqlcode); } sqlerror("update query number 2", &sqlca); goto Uerror; } acctbal = acctbal * (-1); secs2sleep = 90; break; } case 3: { EXEC SQL UPDATE TPCD.LINEITEM set L_DISCOUNT = L_DISCOUNT + :discount WHERE L_ORDERKEY IN (260930, 402497, 457859, 509889, 58117,