rb$ echo $CLASSPATH
            /opt/Apache/db-derby-10.1.2.1-bin/lib/derby.jar:
            /opt/Apache/db-derby-10.1.2.1-bin/lib/derbytools.jar:.
            rb$ mkdir derbyWork
            rb$ cd derbyWork
            rb$ java org.apache.derby.tools.ij
            ij version 10.1
            ij> connect 'jdbc:derby:test;create=true' ;
            ij> exit ;
            rb$ ls -CF
            derby.log       test/
            

rb$ ls -CF test/
            log/                    seg0/                   service.properties
            rb$ ls -CF test/log/
            log.ctrl        log1.dat        logmirror.ctrl
            rb$ ls -CF test/seg0/
            c10.dat         c191.dat        c221.dat        c2c1.dat       c90.dat
            c101.dat        c1a1.dat        c230.dat        c2d0.dat       ca1.dat
            c111.dat        c1b1.dat        c241.dat        c2e1.dat       cb1.dat
            c121.dat        c1c0.dat        c251.dat        c2f0.dat       clearcase/" target="_blank" >cc0.dat
            c130.dat        c1d1.dat        c260.dat        c31.dat        cd1.dat
            c141.dat        c1e0.dat        c271.dat        c41.dat        ce1.dat
            c150.dat        c1f1.dat        c281.dat        c51.dat        cf0.dat
            c161.dat        c20.dat         c290.dat        c60.dat
            c171.dat        c200.dat        c2a1.dat        c71.dat
            c180.dat        c211.dat        c2b1.dat        c81.dat
            

rb$ java org.apache.derby.tools.ij
            ij version 10.1
            ij> help ;
            Supported commands include:
            PROTOCOL 'JDBC protocol' [ AS ident ];
            -- sets a default or named protocol
            DRIVER 'class for driver';   -- loads the named class
            CONNECT 'url for database' [ PROTOCOL namedProtocol ]
            [ AS connectionName ];
            -- connects to database URL
            -- and may assign identifier
            SET CONNECTION connectionName; -- switches to the specified
            connection
            SHOW CONNECTIONS;            -- lists all connections
            AUTOCOMMIT [ ON | OFF ];     -- sets autocommit mode for the
            -- connection
            DISCONNECT [ CURRENT | connectionName | ALL ];
            -- drop current, named, or all
            -- connections; the default is CURRENT
            COMMIT;                      -- commits the current transaction
            ROLLBACK;                    -- rolls back the current transaction
            PREPARE name AS 'SQL-J text'; -- prepares the SQL-J text
            EXECUTE { name | 'SQL-J text' } [ USING { name | 'SQL-J text' } ] ;
            -- executes the statement with
            -- parameter values from the USING
            -- result set row
            REMOVE name;                 -- removes the named previously
            -- prepared statement
            RUN 'filename';              -- run commands from the named file
            ELAPSEDTIME [ ON | OFF ];    -- sets elapsed time mode for ij
            MAXIMUMDISPLAYWIDTH integerValue;
            -- sets the maximum display width for
            -- each column to integerValue
            ASYNC name 'SQL-J text';     -- run the command in another thread
            WAIT FOR name;               -- wait for result of ASYNC'd command
            GET [SCROLL INSENSITIVE] CURSOR name AS 'SQL-J query';
            -- gets a cursor (JDBC result set)
            -- on the query
            -- SCROLL cursors are only available
            -- in JDBC 2.0 and higher.
            -- (Cursor scroll type is ignored in
            -- JDBC 1.X.)
            NEXT name;                   -- gets the next row from the
            -- named cursor
            FIRST name;                  -- gets the first row from the
            -- named scroll cursor
            LAST name;                   -- gets the last row from the
            -- named scroll cursor
            PREVIOUS name;               -- gets the previous row from the
            -- named scroll cursor
            ABSOLUTE integer name;       -- positions the named scroll cursor
            -- at the absolute row number
            -- (A negative number denotes
            -- position from the last row.)
            RELATIVE integer name;       -- positions the named scroll cursor
            -- relative to the current row
            -- (integer is number of rows)
            AFTER LAST name;             -- positions the named scroll cursor
            -- after the last row
            BEFORE FIRST name;           -- positions the named scroll cursor
            -- before the first row
            GETCURRENTROWNUMBER name;    -- returns the row number for the
            -- current position of the named
            -- scroll cursor (0 is returned when
            -- the cursor isn't positioned
            -- on a row.)
            CLOSE name;                  -- closes the named cursor
            LOCALIZEDDISPLAY [ ON | OFF ];
            -- controls locale sensitive data
            -- representation
            EXIT;                        -- exits ij
            HELP;                        -- shows this message
            Any unrecognized commands are treated as potential SQL-J commands
            and executed directly.
            ij>
            

ij> connect 'jdbc:derby:test;create=true' ;
            WARNING 01J01: Database 'test' not created,
            connection made to existing database instead.
            ij> connect 'jdbc:derby:test' ;
            ij(CONNECTION1)> show connections ;
            CONNECTION0 -   jdbc:derby:test
            CONNECTION1* -  jdbc:derby:test
            * = current connection
            ij(CONNECTION1)> disconnect ;
            ij> show connections ;
            CONNECTION0 -   jdbc:derby:test
            No current connection
            ij> set connection CONNECTION0 ;
            ij> show connections ;
            CONNECTION0* -  jdbc:derby:test
            * = current connection
            ij> exit ;