Technical Level : Intermediate
Summary
Windows 10 continues the tradition of hardware compatibility by providing support for a vast collection of devices available within the Windows ecosystem. Hardware detection in particular is an important part of the out of the box experience. Driver software which makes this happen, allows your hardware to function by communicating with the operating system. In this article, we take a look at installing and updating drivers in Windows 10.
Summary
Windows 10 continues the tradition of hardware compatibility by providing support for a vast collection of devices available within the Windows ecosystem. Hardware detection in particular is an important part of the out of the box experience. Driver software which makes this happen, allows your hardware to function by communicating with the operating system. In this article, we take a look at installing and updating drivers in Windows 10.
- Install Db2 Driver On Windows 11
- Install Db2 Driver On Windows 7
- Db2 Driver For Windows
- Install Db2 On Windows 10
To configure the ODBC driver in a Windows environment, create a DSN for the driver: Launch the Windows Data Source Administration Tool: Search on your Windows machine for the launcher for the ODBC Data Source Administration Tool: Once you find the ODBC administration tool, click on the tool to launch it and display the set up window.
Details
I recently installed Windows 10 on an HP Elitebook to see how well the most recent Windows 10 build performs. The Elitebook is a fairly recent model notebook which includes an assortment of hardware technologies. Out of the box though I did not get a complete system, for instance the Intel HD Graphics 3000 was not detected and I was instead limited to the Microsoft Basic Display Adapter.
Apart from this, I had wi-fi ready, which mean, I could connect to the Internet right away.
Installing drivers through Windows Update
Windows Update is the premier starting point to resolve most common driver issues you might experience immediately after installing Windows 10.
Simply launch it from Start > Settings > Update and Recovery and click Check for Updates
or
Press Windows key + R
Type: ms-settings:windowsupdate
Hit Enter
Click Check for updates (make sure you have an active Internet connection).
Immediately, Windows Update will detect your system configuration and download all the appropriate drivers for your system. As you can see in the above screenshot, my Intel HD 3000 Graphics was installed automatically. I did not even have to reboot the system. In addition to other hardware components were also detected and installed which includes my LAN adapter and card reader.
Important Drivers you should get after installing Windows 10.
When you perform a new install or upgrade, you should download the latest software drivers from the manufacturers website for your computer model. Important drivers include: Chipset, Video, Audio and Network (Ethernet/Wireless). For laptops, make sure you download the latest Touch Pad drivers. There are other drivers you will probably need, but you can often download these through Windows Update after have a working Internet connection setup.
How to find and download drivers from the manufacturers website:
Drivers can normally be found in the Support section from the manufacturers website where you will find a Software and Drivers sub-section. The method to find it will vary depending on the brand. You can go to your favorite search engine then enter the following query 'model and make drivers download' example: 'hp 8460p drivers download'. This will often provide a direct link.
Normally, you might not find native Windows 10 drivers. If this is the case, use the latest Windows drivers available for your model. So if they only have Windows 7 drivers, try using those. Make sure you download the right drivers for your architecture (32 or 64 bit).
Proceed to download the appropriate drivers after selecting your version of Windows. The manufacturer might list two versions of the driver, always choose the latest.
Again, the procedures will vary, but as long as you can find the drivers and download section, normally available within Support, you should be able to get to the drivers. If you are reading this before upgrading, try having the essential drivers in advance.
Install drivers using Device Manager
If your driver was not detected or installed by Windows Update, you can try installing the driver manually if you have a compatible version. Windows 10 and previous versions of Windows such as Windows 7 share the same driver model, so it should work.
Press Windows key + X
Click Device Manager
Once device manager is open, select the device, right click it and click Update Driver Software
This will launch the update driver software wizard, which presents two options.
- Search automatically for updated driver software - its possible Windows might have the driver software if you have not checked it yet, if its taking too long, then the next option is usually best.
- Browse my computer for driver software - if there is a compatible driver and you already have the driver files, then all you need to do is point to it and Windows automatically install it for you.
Here I have selected to use an existing driver, browse to where the driver is located on your computer, whether that is a partition, network share, thumbdrvie or install disc. Make sure the option to Include subfolders is checked.
Click Next and wait while the wizard completes the installation.
Using Compatibility Mode to Resolve Driver problems
Install Db2 Driver On Windows 11
If both Windows Update and driver update prove unsuccessful, the next option is Troubleshoot Compatibility. Troubleshoot Compatibility provides a simple way to make older drivers work under modern versions of Windows by making the driver believe it is being installed on a supported version of Windows.
The first thing you need to do is point where the setup files are located. If you are installing from a thumb drive or CD/DVD. Launch File Explorer (Windows key + E) and open the location where the setup files are stored.
Right click the setup file for the program, this can be designated as setup.exe or something similar. Click Troubleshoot Compatibility
This will launch the Program Compatibility Troubleshooter wizard which will check for issues.
Select the option “Troubleshoot program”
Depending on the problems you are experiencing when attempting to install or use the software, check off the problems. In my case:
- ‘The program worked in earlier versions of Windows but won’t install or run now’
- The program requires additional permissions.
Click Next
Select a version of Windows the program is known to work in. I notice the program works great in Windows Vista (with Service Pack 2), so I will select that option. Click Next
Proceed to run the through the programs setup routine by clicking Test the program….
Follow the on screen instructions to install the program as you normally would.
If all is successful, click the option at the end of the wizard ‘Yes, save these settings for this program’
Wait while your settings for the program are saved.
Click Close.
If you have a driver such as your video card automatically installing upon completion of installation and checking for Windows Update, try disabling automatic driver installation using the instructions in the following thread:
Go to the hardware developers website, download the appropriate driver for your model then install in compatibility mode using the instructions above.
How to install your printer:
Resources:
The script content on this page is for navigation purposes only and does not alter the content in any way.
Learn about the requirements and how to install Oracle GoldenGate with a DB2 z/OS database.
Topics:
- System Services
- Memory Requirements
- Disk Requirements for DB2 z/OS
- Operating System Privileges for DB2 z/OS
- Database Configuration for DB2 z/OS
- Database User for Oracle GoldenGate Processes
- Choosing an Installation Operating System
- Installing Extract Components on DB2 z/OS
Parent topic:Installing Oracle GoldenGate for Heterogeneous Databases
5.1 System Services
Activate UNIX System Services (USS) only if required to install the executables for the Extract support modules.
Oracle GoldenGate supports Sysplex data sharing.
5.2 Memory Requirements
Oracle GoldenGate requires the following memory resources on the local system.
The amount of memory that is required for Oracle GoldenGate depends on the amount of data being processed, the number of Oracle GoldenGate processes running, the amount of RAM available to Oracle GoldenGate, and the amount of disk space that is available to Oracle GoldenGate for storing pages of RAM temporarily on disk when the operating system needs to free up RAM (typically when a low watermark is reached). This temporary storage of RAM to disk is commonly known as swapping or paging. Depending on the platform, the term swap space can be a swap partition, a swap file, or a shared memory segment (IBM i platforms).
Modern servers have sufficient RAM combined with sufficient swap space and memory management systems to run Oracle GoldenGate. However, increasing the amount of RAM available to Oracle GoldenGate may significantly improve its performance, as well as that of the system in general.
Typical Oracle GoldenGate installations provide RAM in multiples of gigabytes to prevent excessive swapping of RAM pages to disk. The more contention there is for RAM the more swap space that is used.
Excessive swapping to disk causes performance issues for the Extract process in particular, because it must store data from each open transaction until a commit record is received. If Oracle GoldenGate runs on the same system as the database, the amount of RAM that is available becomes critical to the performance of both.
RAM and swap usage are controlled by the operating system, not the Oracle GoldenGate processes. The Oracle GoldenGate cache manager takes advantage of the memory management functions of the operating system to ensure that the Oracle GoldenGate processes work in a sustained and efficient manner. In most cases, users need not change the default Oracle GoldenGate memory management configuration.
For more information about evaluating Oracle GoldenGate memory requirements, see the
CACHEMGR
parameter in the Reference for Oracle GoldenGate. Allocate approximately 10-50 MB of virtual memory for each Oracle GoldenGate log reader,
oggreadx
, that is invoked depending on the size of the log buffer. There is one invocation per Extract process on the remote system. To adjust the maximum log buffer size, use the TRANLOGOPTIONS BUFSIZE
parameter in the Extract parameter file. When setting up the Wotkload Manager (WLM) environment for the Extract log read components, it is recommended to set
NUMTCB
in the range of 10-40 depending on your environment. This is based on the IBM general guidelines available here: lhttps://www.ibm.com/support/knowledgecenter/en/SSEPEK_11.0.0/perf/src/tpc/db2z_assignprocfunc2wlmappenv.html
5.3 Disk Requirements for DB2 z/OS
(Only applicable if you are installing stored procedures.) Assign a zFS (zSeries file systems) or hierarchical file system volume. To determine the size of the Oracle GoldenGate download file, examine the size of
zOSPrograms.zip
on the remote DB2 system after extracting the installation image. 5.4 Operating System Privileges for DB2 z/OS
The remote host requires privileges to use the
chmod +rw
command on the sub-directories in the Oracle GoldenGate product directory. Table 5-1 shows the other required operating system privileges for Oracle GoldenGate:
Table 5-1 Operating System Privileges
DB2 z/OS User Privilege | Extract | Stored Procedures | Replicat |
---|---|---|---|
CONNECT to the remote DB2 subsystem. | X | X | X |
5.5 Database Configuration for DB2 z/OS
No special DB2 z/OS database settings are required for Oracle GoldenGate.
5.6 Database User for Oracle GoldenGate Processes
Oracle GoldenGate requires a database user account. Create this account and assign privileges according to the following guidelines.
Assign the DB2 privileges listed in Table 5-2 to the user by which Extract and Replicat will be running. These are in addition to any permissions that DB2 ODBC requires. All Extract privileges apply to initial-load and log-based Extract processes, except where noted.
Table 5-2 Privileges Needed by Oracle GoldenGate for DB2 z/OS
User privilege | Extract | Replicat |
---|---|---|
MONITOR2 (does not apply to initial-load Extract) | X | |
SELECT ON the following SYSIBM tables: SYSTABLES SYSCOLUMNS SYSTABLEPART SYSKEYS SYSINDEXES SYSCOLAUTH SYSDATABASE SYSFOREIGNKEYS SYSPARMS SYSRELS SYSROUTINES SYSSYNONYMS SYSTABAUTH SYSAUXRELS | X | X |
SELECT on source tablesFoot 1 | X | |
INSERT , UPDATE , DELETE on target tables | X | |
CREATE TABLE Foot 2 | X | |
EXECUTE on ODBC plan (default is DSNACLI) | X | |
Privileges required by SQLEXEC procedures or queries that you will be using.Foot 3 | X | X |
Footnote 1
SELECT
on source tables required only if tables contain LOB columns, or for an initial-load Extract, if used. Footnote 2
Required if using
ADD CHECKPOINTTABLE
in GGSCI to use the database checkpoint feature. Footnote 3
SQLEXEC
enables stored procedures and queries to be executed by an Oracle GoldenGate process. 5.7 Choosing an Installation Operating System
Oracle GoldenGate for DB2 for z/OS operates remotely on zLinux, AIX or Intel Linux systems. To capture data, a small component must be installed on the DB2 z/OS system that contains the DB2 instance that will allow Oracle GoldenGate to read the DB2 log data.
To install Oracle GoldenGate on a remote zLinux, AIX or Linux system, you have the following options for connecting to DB2 on the z/OS system:
- DB2 Connect v10.5 or greater
- IBM Data Server Driver for ODBC and CLI v10.5 or greater
- IBM Data Server Client v10.5 or greater
- IBM Data Server Runtime Client v10.5 or greater
Consider the following:
- Extract uses Open Database Connectivity (ODBC) to connect to the DB2 subsystem on the z/OS system. If one of the other drivers is not already installed, the IBM Data Server Driver for ODBC and CLI is the most lightweight driver and is recommended for most configurations, although the other drivers are suitable also.
- To capture DB2 log data, the log reader component must be installed in a Library (PDSE) on the z/OS system. Load Libraries (PDS) are not supported. The library must be authorized program facility (APF) helps your installation protect the system. APF-authorized programs can access system facility (APF) authorized. The log read component is called through SQL from the remote system and since it is APF authorized, an authorized Workload Manager (WLM) environment must also be used to run these programs since the default DB2 supplied WLM environment is not able to run authorized workload.
- No special requirements beyond what capture already has are necessary for Oracle GoldenGate delivery. Because this Oracle GoldenGate release is a fully-remote distribution, the former Oracle GoldenGate DB2 Remote product is no longer shipped separately. However, Windows is not supported in Oracle GoldenGate for DB2 z/OS in this release. If you still require delivery to z/OS from Windows, then Oracle GoldenGate DB2 Remote 12.2 is still available.
- UNIX System Services (USS) is no longer required (as in prior releases) except for a few installation procedures.
- Windows only: To apply data to a DB2 target from Windows, Oracle GoldenGate DB2 Remote v12.2 must be used. Capture is not support in this scenario.
- Install Oracle GoldenGate DB2 Remote on a remote system for remote delivery to the DB2 target system. In this configuration, Replicat connects to the target DB2 database by using the ODBC API that is supplied in DB2 Connect . This configuration requires DB2 LUW to be installed on the remote system.Note:All of the Oracle GoldenGate functionality that is supported for DB2 for z/OS is supported by DB2Connect. In addition, ASCII character data is converted to EBCDIC automatically by DB2 Connect.
- Although it is possible to install Oracle GoldenGate on zLinux, AIX, and Intel based Linux, the best performance is seen with a system that has the lowest network latency to the z/OS system that you use. Although it is possible to run over a wide area network, the performance suffers due to the increased network latency. Oracle recommends using a zLinux partition on the same physical hardware as the z/OS system that is running DB2 using Hipersockets or a VLAN between the partitions. Otherwise, systems connected with OSA adapters in the same machine room, would be the next best choice. Alternatively, the fastest Ethernet connection between the systems that is available would be acceptable.
Using the Remote Delivery to the DB2 z/OS using DB2Connect
- For the intermediary system, select any platform that Oracle GoldenGate supports for the DB2 for LUW database. This is the system on which Oracle GoldenGate is installed.
- Install and run DB2 for LUW on the selected remote system so that the Replicat process can use the supplied DB2 Connect driver.
- Catalog the DB2 target node in the DB2 for LUW database on the remote system by using the following DB2 command:
- Add the target DB2 database to the DB2 for LUW catalog on the intermediary system by using the following DB2 command:
See the IBM DB2 LUW documentation for more information about these commands.
5.8 Installing Extract Components on DB2 z/OS
Follow these steps to install the components needed for Oracle GoldenGate for DB2 z/OS for Extract:
Install Db2 Driver On Windows 7
The Oracle GoldenGate DB2 z/OS objects require a minimum hardware platform of z10, a minimum OS release of 1.12, and a minimum DB2 release of 10.1.
- A library (PDSE) must exist on the z/OS system and it must be in the authorized libraries list. This library is the location where the Oracle GoldenGate objects will reside.
- A WLM environment must exist and be APF authorized that references the PDSE from the preceding step. Oracle recommends that NUMTCB for the WLM environment be 10-40 for stored procedures. This depends on the maximum number of Extracts that are running concurrently against the database and on how much throughput each requires. If you want flexibility in selecting NUMTCB, you specify it in the startup JCL for the WLM, but not in the creation panel.
- You can set up security for the WLM application environments and for creating stored procedures by completing the following:
- (Optional) Specify which WLM-established address spaces can run stored procedures. If you do not complete this step, any WLM-established address space can run stored procedures.
- Grant access to users to create procedures in specific WLM address spaces.
- Grant access to users to create procedures in specific schemas. Use the
GRANT
statement with theCREATIN
option for the appropriate schema. - Grant access to users to create packages for procedures in specific collections. Use the
GRANT
statement with theCREATE
option for the appropriate collection. - Grant access to refresh the WLM environments to the appropriate people.
- Ensure that the ID that is used to run the JCL startup procedure for the WLM application environment has permission to use RRSAF. Each time one of the DB2 WLM address spaces is started, it uses RRSAF to attach to DB2. See the DB2 11 for z/OS Installation and Migration Guide
- From the Linux or UNIX installation of Oracle GoldenGate for DB2 z/OS there is a ZIP file called
zOSPrograms.zip
. CopyzOSPrograms.zip
in binary mode to your z/OS system into an HFS directory. - On your z/OS system in USS or OMVS, change directories to the directory containing
zOSPrograms.zip
. - Restore the
zOSPrograms.tar
file with theunzip zOSPrograms.zip
command. - Restore the objects with names with the prefixes
ogg[ir]b[0-9]
,oggib
, andoggrb
in thetar -xovf zOSPrograms.tar
directory. - Copy the objects to the authorized PDSE. Use theNote:In this command, the copy target is double-quote forward-slash forward-slash single-quote authorized PDSE name single-quote double quote. The
-X
is an uppercase capital X not a lowercase x.cp –X ogg[ir][ab][0-9]* “//’authorized_PDSE_name’”
whereauthorized_PDSE_name
is the name of the APF authorized PDSE intended for the Oracle GoldenGate objects. - Using your SQL tool of choice, you must create the SQL procedures so that Oracle GoldenGate can call the Extract process. The Oracle GoldenGate stored procedures should have permission granted to only those users that are used for replication. There is an example SQL script provided in the Oracle GoldenGate install directory that contain the SQL statements to setup the stored procedures on the DB2 for z/OS instance. The
demo_db2_setupb_os390.sql
script is for v11.1 and can be run from any SQL tool on any platform that can connect to your DB2 for z/OS instance. This script should be run on the v11.1 instance you are using with your Extract.The following two lines should be edited before running the scripts:- The
OUT BUFFER BLOB
line must be modified to be at least a large as the largestTRANLOGOPTIONS BUFSIZE
value that is being used in your Extracts. Oracle does not recommended that you make the BLOB size any larger than necessary. - The
WLM ENVIRONMENT
line must be modified to use the correct name for the WLM environment that you are using.
Db2 Driver For Windows
Note:
Install Db2 On Windows 10
The
oggifi0001
schema name is configurable using the TRANLOGOPTIONS REMOTESCHEMA schemaname
parameter. The procedure names are not configurable. The external name must match the program name of the object stored in the PDSE and remember to change the WLM environment to match the name of the WLM environment setup for the Oracle GoldenGate stored procedures. Note:
The out buffer BLOB size should be sized so that it is not smaller than the value of
TRANLOGOPTIONS BUFSIZE
. You may set the size of the buffer BLOB to be equal to the TRANLOGOPTIONS BUFSIZE
value to limit memory resources used on the z/OS system. The exact value of the buffer depends heavily on the workload being processed by the Extract so heavier loads may require a larger buffer to enable Extract to be able to keep up with the application.