Downloading files from the host to the client

This section describes how to download the input data for these functions from the host to the client.

About this task

The following Buffer Pool Analyzer functions are performed on a Windows-based client and require input data from the host.

You can use any file transfer method or product, for example, the File Transfer Protocol (FTP) or IBM® Personal Communications. You must have at least one of these products installed on your client. The following procedure describes the basic steps to download files. For more information, see the product documentation.

If you have the choice, you should use FTP, because it is faster.

If you need to download large trace data files (for simulations), consider using compressed trace data sets to reduce download times. See Collecting data for instructions how to create compressed data sets. The simulation function automatically extracts compressed trace data files.

On the client, create a folder where you want to store the files to be downloaded. For example, in the Windows Explorer file list:
1. Click the C drive.
2. Click File —► New —► Folder. A new folder icon is displayed.
3. Rename the folder icon to a meaningful name, for example bp_data.
  It is recommended to keep buffer pool data files (used for viewing performance data and optimizing the object placements) and trace data files (used for simulations) in a single folder. This helps to keep together bpd files and trace data files that were created on the host from the same buffer pool trace data. You can distinguish them by their file name extensions (bpd or trace).
Note that Buffer Pool Analyzer does not provide means to delete downloaded files. They remain on the hard disk drive, and take up space, until you delete them.
If you want to use FTP to download files:
If your File Transfer Protocol (FTP) program provides the RDW and NORDW command options, ensure that the NORDW command option is active.
1. Open a Command Prompt window on your client and start an FTP dialog with one of the following commands:
  - ftp <hostname>, whereby <hostname> denotes the name of your host
  - ftp <IP address>, whereby <IP address> denotes the IP address of your MVS host
2. Enter your MVS user ID and password and wait until the current client folder is displayed.
3. Enter binary to set the transfer type to binary.
4. Enter lcd <client_directory>, whereby <client_directory> denotes the local directory where you want to store the files (the folder that you created in step 1). If you do not specify a directory, the current directory on the client is used.
5. If you do not remember the data set name you want to download, enter dir or ls to get a list of your data sets.
6. Enter get <file_name> <new_name>, whereby <file_name> denotes the fully qualified host data set name in quotes, and <new_name> denotes the client file name without quotes.
  This starts the download.
7. Enter quit to leave the FTP program, or download more files as required.
Example: The following figure shows an example of an FTP session.
```
C:\bpa>ftp boepm01
Connected to boepm01.boeblingen.de.ibm.com
220-FTPD1 IBM FTP CS V1R2 at BOEPM01.boeblingen.de.ibm.com, 13:53:23 on 2003-05-
20.
220 Connection will close if idle for more than 60 minutes.
User (boepm01.boeblingen.de.ibm.com:(none)): wtn
331 Send password please.
Password:
230 WTN is logged on.  Working directory is "WTN.".
ftp> bin
200 Representation type is Image
ftp> lcd c:\bpa
Local directory now C:\bpa.
ftp> get 'WTN.TEST.TRACE' test.trace
200 Port request OK.
125 Sending data set WTN.TEST.TRACE
250 Transfer completed successfully.
ftp: 1768197 bytes received in 1.34Seconds 1317.58Kbytes/sec.
ftp> get 'WTN.TEST.BPD' test.bpd
200 Port request OK.
125 Sending data set WTN.TEST.BPD
250 Transfer completed successfully.
ftp: 149487 bytes received in 0.43Seconds 347.64Kbytes/sec.
ftp> quit
221 Quit command received. Goodbye.

C:\bpa>dir test*
 Volume in drive C is C_DRIVE
 Volume Serial Number is 6C10-18AA

 Directory of C:\bpa

20.05.2003  16:06              149 487 test.bpd
20.05.2003  16:06            1 768 197 test.trace
```
If you want to use IBM Personal Communications to download files:
1. Log on to your Multiple Virtual Storage (MVS) session on the z/OS® or OS/390® system. Ensure that your MVS terminal is in READY mode. Note that keyboard entries in lowercase are converted to uppercase on the host.
2. Start IBM Personal Communications on your client and click Receive.
3. In the Host file field, type the name of the data set that contains the data to be downloaded.
  Example: 'sample.bpd', a buffer pool data file. Do not forget the quotes.
  
  Example: 'bpasim.trace', a trace data file. Do not forget the quotes.
4. In the PC field, type the destination folder and file name.
  Example: c:\bp_data\sample.bpd for a buffer pool data file
  
  Example: c:\bp_data\bpasim.trace for a trace file
5. In the Transfer type field, select BINARY.
  This step starts the download.