Db2 Commands

The following is a quick reference for the most commonly used DB2 CLP commands. By describing a table he meant getting a list of columns of a table together with the. Backup and Restore Agents > Backup Agents > DB2 > DB2 Backup Administrator Guide > DB2 Application Command Line Backups. First connect to the sample database:. To stop DB2 on your system, you. The DB2 command ACCESS DATABASE forces a physical open of a table space, index space, or partition, or removes the GBP-dependent status for a table space, index space, or partition. Let us go in step wise. The few commands which every user using DB2 will require. DB21024I This command is asynchronous and may not be effective immediately. 2 under Windows. DB2 Display Commands. SC09-4828-01 Before using this information and the product it supports, be sure to read the general information under Notices. Posted by santuswathi on Feb 6 at 2:29 AM. For a manual incremental restore, the RESTORE command is issued once for each backup image. db2 deactivate #Deactivate an active database db2 drop database #Delete and instance db2 force application all #Close all applications that uses DB2 Database. If you want to run a series of commands in batch, i. 1 or Windows 3. Look for job requirement for data warehousing jobs. After entering in the table name and the number of columns, the tool allows the user to enter the following information for each column of the table: Column Name Column Type (for example, Integer, Char, Varchar, etc. This entry was posted on June 19, 2012, 8:35 pm and is filed under DB2, DB2 Administration, DB2 built in commands, DB2 Maintenance, db2advis, IBM, SQL Performance. DB2 for Linux,UNIX,andWindows Command Reference Updated July, 2012 Version 9 Release 7 SC27-2439-03. db2 create db databasename - creates the database 2. You can adapt some tools to perform what you want: Have a master table (MDM) in a database and have a replication or federation in the other databases. ixf of ixf messages /tmp/load_ixf_department. db2 list db directory show detail Delete db catalog. The command line is a simple and reliable interface that makes scripting and automation for Db2 easy. Right after the installation of DB2, your browser should have automatically launched starting "DB2 First Steps". You generally have to pull up a DB2 Command Window and use db2cmd. To execute the commands on a normal console, there is not need to enter the first slash. This makes your SQL query so simple. Issue the DB2I command in TSO and you should be presented a menu which has option 7 DB2 Commands. I am not an employee or affiliated with IBM in any way. Download a single, full-featured version of the Db2 Community License edition for as long as you'd like. DB2 Application Command Line Backups. hello experts, I am not exactly sure how I can read the results of a db2 command and use it as a variable for a shell script. db2 create db databasename using codeset utf-8 territory us collate using system - creates the database with utf-8 support. db2 list tables - lists tables in the DB. I want to know that how to create a new user in DB2 database and set the password for it. we use db2 v9. View videos. two select statements on one line? - IBM DB2. You can run DB2 SQL commands. DB2 Basic Commands - UDB 1. Orange Box Ceo 8,344,099 views. You will receive immediate results after submitting your SQL commands. Net Framework that Microsoft also developed. Please use code tags as required by forum rules! This is a hell of a quoting problem. About the IBM DB2 for LUW Audit Events. RESTORE DATABASE comes handy when you are not able to backup your corrupted or damaged DB2 database by using inbuilt DB2 backup utility. Port is 50000. The opinions expressed herein are the author's, and should not be construed as reflecting official positions of the IBM Corporation. Explore the three modes in which the CLP operates, get a detailed explanation of the db2 command, and learn some recent usability enhancements that are sure to please command line users. DB2- Date, Time, Timestamp. These commands are used for the following operations: Start a DB2 interactive session To start an interactive session, enter the follow command: db2. There have always been some samples in DB2 for some things like user exits and some code stubs, but as of DB2 v9. To create ODBC data sources manually using DB2 commands, complete the following steps: Open a DB2 Command Line Processor window: For Windows systems, click Start -> Programs -> IBM DB2 -> Command Line Processor. Update the DB2 Enterprise Server Edition (ESE) license policy to reflect registered and concurrent users. Also, after set how to change the password. 5 on Windows. Using PowerShell as Your Command Line. TABNAME on all columns with distribution and sampled detailed indexes all tablesample bernoulli(10) set profile only; (runstats doesn't execute but only the profile is set). db2 list db directory show detail Delete db catalog. Sample output from db2 inspect and db2inspf: $ db2 connect to sample $ db2 inspect check database results inspect_sample. IBM Knowledge Center is now the home for all official Db2 for z/OS product information on the web. RESET QUERY(LANG=PROMPT command on the command-line. All tests were performed on DB2 8. 19 December 2008. The opinions expressed herein are the author's, and should not be construed as reflecting official positions of the IBM Corporation. Check that DB2 is started on the DB2 Connect gateway. You can issue these commands from the DB2 subsystem object. When using IBM DB2, there may come a time where you wish to view the structure of your database or even of specific tables. SELECT INSERT UPDATE DELETE SELECT SELECT statement is used to get all data or required data from the table. With solutions for Toad for Oracle, Toad for MySQL, Toad for SQL Server, DB2, SAP and more. TSO/E is a base element of z/OS. Start Settings > Control Panel >Administrative Tools > Computer Management > System Tools > Local Users and Groups> Groups Right Click on 'DB2USERS' group and select properties Select Add Enter user 'SASDEMO' and select Check Names Select Ok Select Apply. These topics provide detailed reference information for Db2 and related commands, including the environment in which each command is issued, the privileges and authorities that are required to issue each command, syntax and option descriptions, usage information, and examples. According to IBM, DB2 leads in terms of database market share and performance. If the db2 server and the load directory is not on the same host, add the client keyword after the load : ex db2 load client …. DB2 query to select first or last N rows There may be instances when you wish to select first or last N rows. If you are just developing an application which uses DB2, you don’t have to install whole DB2. db2 => connect to sample db2 => bind sample. db2 list command options - displays the available Command Line Processor (DB2CMD) settings. Here are some quick and dirty instructions on how to import data that you have in a file into a DB2 table. DB2 commands : TERM, START, STOP, DIS - DIS or -Display : Display a status of tablespace (ie READ-WRITE / COPY-PENDING / CHECK-PENDING / READ ONLY). Execute db update script (Downtime). Start the database manager and enter the db2 command line db2start:This command will help you start the database manager. SC09-4828-01 Before using this information and the product it supports, be sure to read the general information under Notices. Issue the DB2I command in TSO and you should be presented a menu which has option 7 DB2 Commands. The user ID who creates the synonym must have SELECT authority for this object type. This command is also available in conversion mode. msgs remote file stafftmp replace into staff using. This article shows you how to use the Command Line Processor (CLP) to your advantage. The db2set Command. To get the Current TimeStamp in DB2 , use the following query SELECT current timestamp FROM sysibm. These commands are used for the following operations: Start a DB2 interactive session To start an interactive session, enter the follow command: db2. But popular ways among different SQL Servers are "FETCH FIRST 5 ROWS ONLY" and "TOP 5" etc. The IBM Db2Universal Database (UDB) command line processor (CLP) is a convenient interface for accessing Db2 functions. RESET QUERY(LANG=PROMPT command on the command-line. DB2 Application Command Line Backups. Then you can run this command file as follows. Use the DB2® for z/OS® and related commands to execute database administrative functions. DB2 is a database server developed by IBM. Mainframes Online Training: copybooks CICS commands SEND, RECEIVE & RETURN Triggering CICS transactions IBM DB2, Mainframes DB2, IBM CICS, IBM Training, JCL. About the IBM DB2 for LUW Audit Events. Port is 50000. I open db2cmd and paste command, and it does not work. Since after third position it starts searching. Command Reference. It is a Relational Database Management System (RDBMS). Therefore "I am forced" to use singe quotation marks With double qoutes, I get. Supplement: DB2 set schema BTP to modify the current model"btp" DB2 list tablespaces show detail to view the current database table space distribution. Search this site. Download a single, full-featured version of the Db2 Community License edition for as long as you'd like. DB2 UDB Version 8. For example, from the DB2 Command Line Processor (CLP), the following SQL statements reveal similar information:. Do I need to go to certain path in that db2cmd to commands t. ) Length or Precision. World #1 site for IBM Mainframe Computers with Support Forums, Free Downloads, IBM Manuals, Tutorials & Job openings since 1998. LIST HISTORY. These topics provide detailed reference information for DB2 and related commands, including the environment in which each command is issued, the privileges and authorities that are required to issue each command, syntax and option descriptions, usage information, and examples. First connect to the sample database:. DB2 10 for z/OS Technical Overview Paolo Bruni Rafael Garcia Sabine Kaschta Josef Klitsch Ravi Kumar Andrei Lurie Michael Parbs Rajesh Ramachandran Explore the new system and application functions Obtain information about expected performance improvements Decide how and when to migrate to DB2 10. Using TOAD for DB2 GUI. If your DB2 client is a different version or release level than your DB2 server, you may need to bind the DB2 Client packages. About the IBM DB2 for LUW Audit Events. In case you are working in DB2LUW (Windows) first run db2clw in your command window(or in Run). 6 DB2 and the Joy of Rexx • DB2 Commands • On LUW, call the Administrative APIs or the DB2 Command Line Processor or ADMIN_CMD procedure • Call SQLDBS ’CATALOG GLOBAL DATABASE. Command Reference. The following IBM DB2 commands are recommended for regular maintenance of your AEM forms database. 57,55,Secretary,8,1983-8-14. In the picture below, the window alerts you to type the Table-Name. View Amit Sanyal’s profile on LinkedIn, the world's largest professional community. You can issue these commands from the DB2 subsystem object. Hi, On 05/26/06 03:18, re*****@gmail. The command center provides a direct option, but importing CSV files via SQL commands allows you to manipulate or change the data before you add it to the table. But it can sometimes be easier to read in the IBM DB2 Information Center, and may have links to other useful information. 8 Utilities Allow you to control the operation of DB2 utility programs, which run separately from the DB2 processor. IBM Knowledge Center is now the home for all official Db2 for z/OS product information on the web. I would recommend reading the DB2 documentation for that. SqlDbx Personal Edition is a free version of the Professional Edition, and is for personal non-commercial use. log replace into department2. Screen output will be dumped to the logfile specified with option -z. So far, I'm able to run PSSH to a file of servers with no check for keys, open every xterm in the servers in the file list, and sudo to the SAP (ADM) user, but it won't do anything else afterwards. db2cmd /c /w /i db2 -v TERMINATE. For that reason, most installations monitor DB2 from the product’s own facilities. The command line processor is a program that runs under z/OS UNIX System Services. Db2 can be administered from either the command-line or a GUI. IBM DB2 Universal Database Command Reference Version 8. This command is also available in conversion mode. Are you able to authenticate to the LDAP server outside of DB2? Are you able to query the groups within LDAP for the user outside of DB2? Is the performance accessing the LDAP outside of DB2 similar to within DB2? Can the problem be reproduced on demand? If so, can a test case or a sequence of steps can be provided? Impact. It’s not fun, and the only scenario you might come out of messing with them with Kudos is if you’re dealing with an expired Try&Buy license – and then only if it’s someone else’s fault there was a Try&Buy in the first place. These are the list of commands: 1. To run a command against the current database, use db. 5 System Views and Table Functions - Duration: 49:47. Toad World Blog. If you are using the Super User (su) on Linux for db2iupgrade command, you must issue the “su” command with the “-” option. runstats: This command updates statistics that describe the physical. More information can be found here. Using TOAD for DB2 GUI. You can specify the media parameters in a file. I can perform DB2 commands in the administrator command window, but I would prefer to use the regular command window. Create user in DB2 - IBM DB2. To create ODBC data sources manually using DB2 commands, complete the following steps: Open a DB2 Command Line Processor window: For Windows systems, click Start -> Programs -> IBM DB2 -> Command Line Processor. (DB2 will be installed in /opt/IBM/db2/V9. It does not affect other sessions, and it has no effect on the DB2 server. The CLP accepts commands or SQL statements from a DB2 command line. runstats: This command updates statistics that describe the physical. The command recognition character '-' is required. The opinions expressed herein are the author's, and should not be construed as reflecting official positions of the IBM Corporation. This page provides links to IBM Knowledge Center, alternative documentation formats such as PDF manuals, and other Db2 information resources. Cataloging a node in an IBM DB2 Universal Database client. Please help me, if theres a way we can execute DB2 commands directly from the windows cmd prompt window instead of executing those from DB2 CLP window. The file will be written out to the diagnostic data directory path. Simple Syntax SELECT Column Names > / * / function( Column Name >) FROM TABLE NAME > [ WHERE Condition > ] Example (s) 1. In the output of that command you'd see this field and an accompanying value: QUEDBAT= 0 The QUEDBAT value indicates the cumulative number of times that the MAXDBAT limit was hit for the Db2 subsystem since DDF was last started (which probably would be when the Db2 subsystem was last "bounced," or stopped and restarted). /db2_install -b /opt/IBM/db2/V9. You can use the command line processor to execute SQL statements, bind DBRMs that are stored in HFS files into packages, call stored procedures, and perform XML schema repository operations. This makes your SQL query so simple. If the ssid is specified, DB2INFO blocks for only matching DB2 subsystems are displayed. This is because the command creates the file onto the active log drive. Note: If you run DB2 v10. 6 DB2 and the Joy of Rexx • DB2 Commands • On LUW, call the Administrative APIs or the DB2 Command Line Processor or ADMIN_CMD procedure • Call SQLDBS 'CATALOG GLOBAL DATABASE. In working with your database, you might notice a certain DB2 process consuming a high amount of CPU space. The opinions expressed herein are the author's, and should not be construed as reflecting official positions of the IBM Corporation. In summary: Is there any steps from which we can run the db2 commands without using the db2cmd. Inspired by a recent developerWorks article "IBM AIX Commands You Shouldn't Leave Home Without", I developed DB2 Commands 101. Run db2level from command line. Writing SQL with Examples on DB2 10. To execute your sql command type the following at the command line (substitute with the name of the database you want to connect to):. DB2 Application Command Line Backups. The command db2stop force will bring down an active instance by force and will stop the instance. Db2 is a well established relational database that also supports unstructured data. For detailed information about maintenance and performance tuning for your DB2 database, see IBM DB2 Administration Guide. When an INSERT happens, DB2 finds the candidate page affected. Customizing DB2 Administration Tool V11. On UNIX or Linux, navigate to the IBM DB2 Universal Database server or IBM DB2 Universal Database client sqllib directory, which is located in the IBM DB2 Universal Database instance owner user home directory. ddl' dsmc q ba 'run*' -inactive dsmc restore 'runstats. 11 for Workgroups. Hi, On 05/26/06 03:18, re*****@gmail. A database is a collection of Tables, Schemas, Bufferpools, Logs, Storage groups and Tablespaces working together to handle database operations efficiently. Even drag and drop capabilities are already programmed into these tools. At the command line invoke the 'DB2START' command. Just installing DB2 ODBC CLI Driver will be enough to be able to connect to DB2. DB2- Date, Time, Timestamp. This way, the second (running PRUNE HISTORY) does no longer find a connection to "sample" database, since CONNECT ran in a different DB2 Command Window. I wish, I could, but the DB2-command, does not allow for double quotation marks. The opinions expressed herein are the author's, and should not be construed as reflecting official positions of the IBM Corporation. About This PL SQL Programming Tutorial. You should type the command exactly as shown in a window whose title is DB2 CLP. This appendix maps audit event names used in IBM DB2 for LUW to their equivalent values in the command_class and target_type fields in the Oracle AVDF audit record. The MODE keyword specifies the desired state. Verify that the DB2 archive log path and the DB2 retrieve path are empty. Note: This command will only affect CREATE INDEX requests issued by CREATE FILE and HOLD FORMAT DB2 commands. DB2 commands <[login to unmask email]> 03/23/01 12:58 PM Please respond to DB2 Data Base Discussion List Hi all, Ok I've decided lean some REXX (one more thing to be mediocre at:-). Our DBAs has requested us to use this clause on many select statements so that DB2 won't escalate a lock to a table lock. Sharing frequent used DB2 commands. This utility can be used to duplicate the connectivity information from another similar instance that was configured previously. db2 load from /tmp/department. You can check the list of db2 application with the command given above (ps = -aef|grep db2|wc -l). If you are using Windows 8 and want to connect to IBM DB2 using Power Query, you need to follow additional installation steps. or your alternative is from the command line: db2 " import from 'testfile' of del insert into workemployee" db2 < test. This article will help you learn the basics of DB2. com wrote: Can you please let me know the procedure to reach db2 command prompt from a cygwin window Have a look at your Windows environment variables and add those used by. The following video tutorial will help you understand the SDSF. Risk Involved. The command recognition character '-' is required. DB2 Restore Examples Using the DB2 Command Line Interface. The audit events are organized in useful categories, for example, Account Management events. You may have to register before you can post: click the register link above to proceed. DB2 CATALOG TCPIP NODE DB2NODE REMOTE MACHINE215 SERVER 50000 --catalogs node. Command Reference. Since CICS is the coordinator of the two phase commit process, you must use EXEC CICS SYNCPOINT or EXEC CICS SYNCPOINT ROLLBACK commands instead. hi , I am new to db2 database I have the following query 1. Woburn, MA. Sharing frequent used DB2 commands. You generally have to pull up a command window and use db2cmd when executing batch scripts or DB2 commands from batch scripts. Command Parameters:-d: Turns debugging mode on. These command examples are from my own experience of 15 years as a DB2 DBA. This is available on all DB2 v9. For a manual incremental restore, the RESTORE command is issued once for each backup image. When executing from SDSF, we need to tell that we want to execute an MVS-command and need to enter the preceding /. An SQL council formed by several industry leading companies determines the standard for these SQL statements, and the different relational database management systems (RDBMSs) follow these standards to make it easier for customers to use their databases. You have several steps you need to complete before you configure a connection to a remote DB2 database on Linux, In a command window, run the following commands. db2 commands in shell script. Initially, IBM had developed DB2 product for their specific platform. Pop-up Windows are used to collect information from the user, about the data you wish to search for and extract. From the DB2 Command Line Processor (CLP), issue the following SQL statements db2=> VALUES current date - displays the current date. Right after the installation of DB2, your browser should have automatically launched starting “DB2 First Steps”. Sharing frequent used DB2 commands. Db2 for i is a member of IBM’s family of Db2 databases. Dropping an instance. (CICS Commands). I want to get one at a time to process. Start Settings > Control Panel >Administrative Tools > Computer Management > System Tools > Local Users and Groups> Groups Right Click on 'DB2USERS' group and select properties Select Add Enter user 'SASDEMO' and select Check Names Select Ok Select Apply. About the IBM DB2 for LUW Audit Events. If the ssid is specified, DB2INFO blocks for only matching DB2 subsystems are displayed. CLP Commands; DB2 CLP Commands; ACTIVATE DATABASE; ADD NODE; ATTACH; BACKUP DATABASE; BIND; CATALOG APPC NODE; CATALOG APPCLU NODE; CATALOG APPN NODE; CATALOG DATABASE; CATALOG DCS DATABASE; CATALOG GLOBAL DATABASE. DB2 and Oracle provide the UPDATE statement to update existing rows in a table, but there are differences in the syntax. Therefore "I am forced" to use singe quotation marks With double qoutes, I get. From the CLP Command Line Mode, you can also execute system commands like "db2pd" that you can't execute from Interactive Mode or the GUI Command Editor. DB2 Display Commands. Several Unix dialects use the whereis command to find where programs, or executables, are stored in the file structure of the computer. Another advantage that SQL has over DB2 is in the. Simple Syntax SELECT Column Names > / * / function( Column Name >) FROM TABLE NAME > [ WHERE Condition > ] Example (s) 1. I should have these commands in a batch file that should be executed from windows cmd prompt. The DISPLAY DATABASE command can be issued for a specific tablespace from the DB2 Tablespace object. ) How can we check the scheme owner of the db2 database. 19 December 2008. DB2 LIST DATABASE DIRECTORY -- list databases. Example 2: SELECT LOCATE('I','MINE STRING',3) FROM SYSIBM. Difference in number of day using DB2 days function. Here are some useful commands for DB2 and don't forget to execute these commands using DB2 instance user (db2instX): db2 list active databases # list databases db2 activate database [dbname] # activate database db2 list…. They require the DB2 subsystem to be currently active. db2 create db databasename using codeset utf-8 territory us collate using system - creates the database with utf-8 support. test" TESTCOL ----- 0 record(s) selected. hello experts, I am not exactly sure how I can read the results of a db2 command and use it as a variable for a shell script. Are you a new DB2 LUW DBA? A OS System Administrator covering for your DBA? Or just need a quick reference guide? This should help. The command will return numerous parameters (see Figure 3). Supply the first expression. 7 DB2 COMMANDS (Issue DB2 commands) 8 UTILITIES (Invoke DB2 utilities) D DB2I DEFAULTS (Set global parameters). If table B foreign key refers table A's primary key, DB2 / ORACLE wont allow to enter the records into table B if the foreign key value in the input data is not present in the table A's primary key list of values. Expect to have lots of code, commands and to roll up your sleeves. Multidimensional Clustering Table (MDC): This type of table physically clustered on more than one key, and it used to maintain large database environments. log file to check that DB2 TCP/IP communications have been started. Use any of the following methods to run a DB2 (R) command:. a client of the database such as your workstation. DB2 10 for z/OS Technical Overview Paolo Bruni Rafael Garcia Sabine Kaschta Josef Klitsch Ravi Kumar Andrei Lurie Michael Parbs Rajesh Ramachandran Explore the new system and application functions Obtain information about expected performance improvements Decide how and when to migrate to DB2 10. The DB2 plan contains date and time stamps, and all the details about how DB2 data is to be handled by programs. runstats: This command updates statistics that describe the physical. They require the DB2 subsystem to be currently active. SYDUMMY1 It returns value 2. So the process would be :-. 2 The first query All the above effort is done to finally have data that can be investigated. Search this site. This allows you to create your data in a separate program and upload it directly into your DB2 tables to save time. If the switch is set at the DB2 instance level, the get snapshot or table function can be run from any session with a connection to the database. DB2 is designed to store, analyze and retrieve the data efficiently. When you reset the Language to Prompted Query, a Prompt-Window appears. Robert's Db2 blog This is the blog of Robert Catterall, an IBM Db2 for z/OS specialist. For information on specifying the media parameter file, see Specifying the Media Parameters for DB2 Command Line Operations. Objective: You have a set of SQL DML (or other, such as DDL) statements that you want to run as a file using the CLP db2 -f filename option. x database? Posted by Vivek Agarwal on April 6, 2008 Recently, I installed Quickr v8. Inspired by a recent developerWorks article “IBM AIX Commands You Shouldn’t Leave Home Without“, I developed DB2 Commands 101. So please If anybody knows about, how should we execute the db2 commands without creating the another command prompt. IBM DB2: Five Ways to Discover the Hostname of an iSeries Server for Use in a Four-Part Table Name Posted on February 17, 2009 by Chrissy LeMaire — 6 Comments ↓ I admit, I don’t have too much experience with DB2 yet. These command examples are from my own experience of 15 years as a DB2 DBA. When DB2 ruled the mainframe world, IBM sought to make OS390 DB2 more readily available for platforms outside MVS/ESA. The DB2 which runs on the mainframes is basically a DB2 server; every server has an IP address and a port number which can be used to access the server. It gives the heritage DB2 person a new report generation tool. db2 deactivate db Delete tables. Yes, Virginia, there is a DB2 load command. Toad World Blog. Use the DB2 command line interface to perform Commvault restores when the Commvault interface does not support the commands or options, or when you do not want to use the CommCell Console interface. Use the Db2 for z/OS® and related commands to execute database administrative functions. These command examples are from my own experience of 15 years as a DB2 DBA. I am new to unix scripting so pleas | The UNIX and Linux Forums. IBM DB2 Universal Database Command Reference Version 8. If you are a beginner DB2 admin like me, you may find DB2 has different way compared with Oracle DB. For information on specifying the media parameter file, see Specifying the Media Parameters for DB2 Command Line Operations. The CLP accepts commands or SQL statements from a DB2 command line. The following command will retrieve the JCC driver version if executed from the command line: java com. Oggetto: [DB2-L] - RE: routing db2 commands in batch Hello, Sorry for being unclear. In addition, we will also see how to call Java from an RPG program. $ db2 ROLLBACK DB20000I The SQL command completed successfully. Find more information about the IBM DB2 Data Server Driver on Windows 8. ddl' -inactive. SELECT INSERT UPDATE DELETE SELECT SELECT statement is used to get all data or required data from the table. DB2 Tutorial - This tutorial provides you the basic understanding of concepts of database, database installation and management. DB2 Basic Commands - UDB 1. Connecting to DB2 database on a mainframes. How do you rename the Windows machine name for a DB2 v9. Create user in DB2 - IBM DB2. db2 commands in shell script. SQL Commands is a website demonstrating how to use the most frequently used SQL clauses. Updating the Directories. DB2 Utility Commands RUNSTATS: =>db2 runstats on table TABSCHEMA. db2 uncatalog db dbname. Note: This command will only affect CREATE INDEX requests issued by CREATE FILE and HOLD FORMAT DB2 commands. The online inspect check processing will write out unformatted inspection data results to the results file specified. DB2 Basics Tutorial Part 1. Running DB2 commands.