db2-> create table employee ( Empno smallint, Name varchar(30)) Create a schema If a user has SYSADM or DBADM authority, then the user can create a schema with any valid name. When a database is created, IMPLICIT_SCHEMA authority is granted to PUBLIC (that is, to all users). The ...
( In this file, we have two sets, one is no rest log case and the second one is reset log case, here I am choosing the rest log set, otherwise you can take no rest log case also. And remove the above line up to create control file command) Create controlfile reuse database “wi...
1. Create or use two existing tablespaces on the source database. Although having two tablespaces is not necessary, it was merely shown here to exercise object dependency. Note that OMF is being employed in this illustration, thus please set the init.ora parameter DB_CREATE_FILE_DEST to the ...
having ID of 123.This type of queries are pretty common. The query will get to row of ID = 123 really fast, because DB2 will get it from unique index. So far so good, but in order to get other columns, DB2 needs to go to that row in actual table and get first and last name!
I have installed ERP 6.0 EHP4 with DB2 V9.1 FP7 But i also want to know status: Used space 100% in tab "Database and Tablespace" via tcode DB02. What happen with this status ? and I need to do to remedy this situation.
2.createtabletable2liketable1; 3.loadfromsomedata.delofdelinsertintotable2; While the load process is in flight , create another connection and view the progress loadtable2; 3.connectreset; Read More on topics related to How to check DB2 LUW load status ...
You can create a SQL Job which runs every 1 minute and tries to query the database. On failure of the job you can set it to notify you via email. Another option is to query sys.databases prettyprint 複製 select state from sys.databases where name = 'Database_name' Depending on th...
CREATE TABLESPACEcreates a Db2-style tablespace to store tables from the same logical database in multiple directory paths. The tablespace is used with a stogroup. CREATE ALIASdefines an alias for an existing table or view. The alias may be described in a different location as the table or ...
Dropping unused triggers can improve import performance by reducing the system overhead used to verify trigger constraints. You can use the Generate Triggers (GenTrig) component from Siebel Server Tasks to drop the triggers and to re-create them later on. This component must be in the Enabled...
Solved: Dear All, I have DB2 9.1 fix pack 5 running on SUSE LINUX 10 with SAP ECC 5.0 db2 storage management is automatic storage. I am unable to add a new container in