Database Administrator

This article outlines six methods to execute DB2 commands. Environment product: DB2 UDB Platform: z/OS Version: v8 Q: How do I execute DB2 commands? A: You can run the following DB2 command: 1. Use the z/OS console or z/OS applications for

Developing Internet applications is complicated: You must not only define the behavior and logic of applications, but also combine multiple products, technical layers, and standards in a distributed environment. The sample code shows a variety of

Shared Server under Oracle 9i (multi-thread Server MTS in 8i) It is mainly used in OLTP services. It takes only a short time for a server process to process the business, and most of them are in idle State. In this case, fewer resources can be used,

The data synchronization function of mysql not only provides load balancing for database queries to a certain extent, but also provides great help for database redundancy, backup, recovery, and load balancing. The data synchronization function can

The following three statements are used to refresh the Oracle cache. Here is a summary. 1)Alter system flush global context Note: For multi-tier architectures such as application servers and data block servers that communicate through the

In order to install Oracle on Windows 7x64, the system tried two days and downloaded several files, prompting various errors, such as unsupported operating system. The final success was recorded. 1. download the latest Oralce 11gR2. Only this

Install omsBefore logging on to oms, you must first install the oms service. Start Oracle universal installer, check the installed products, and expand oracle main directory-oraHome92. If oracle9i management and integration is not available, it

The stored procedure is used in many places when the data center is reconstructed. Here is a brief summary. Stored Procedure is a set of SQL statements for specific functions. It is compiled and Stored in the database. You can run a stored procedure

Today, the customer received their own test environment, resulting in a table from the source database to the target database, select * from tabname reported ORA-01435: user does not exist, select count (*) from tabname normal, I used to only

GC Resource ManagerOfficial documentation: administrator's Guide-> 24 Using the Database Resource ManagerUsage: less used in the actual production environmentPurpose: restrict the use of database resources, CPU memory undo tablespace I/O

Preface I have recently studied MongoDB, mysql, MSSQL, and Oracle, but they are all SQL-based and table-based relational databases. I understand it, but I know something about it. MongoDB is based on documents. So what is MongoDB? Five Things should

I. concepts related to RMAN backup 1. in RMAN backup, The tablespace does not need to be in backup mode. It backs up data files, archive log files, control files, spfiles, and backup sets, but does not back up online redo log files, temporary files

I started to learn about Oracle, so today I plan to install Oracle 10 Gb. After the installation is complete, test whether the job works normally. During installation, the global database configured is tmt. However, when using SQL Plus to log on,

After installing mysql on CentOS 6.4, I cannot access it through root. Because the root password is not set during installation, it seems that there is an initial random password, but I do not remember it, too troublesome. Reset the root password

I have been in the Oracle DBA industry for several years, but speaking of Oracle Installation experience, I am not very familiar with it. At the beginning, I was a little confused, as Oracle has become more and more familiar with the principles and

ORA-00980: synonym translation is no longer valid ORA-00980: synonym conversion is no longer valid Master TOM's explanation of the error: http://asktom.Oracle.com/pls/asktom/f? P = 100: 11: 0: P11_QUESTION_ID: 7095288486502  That means you lost some

8.3.3 Using Transportable Tablespaces with a Physical Standby Database 8.3.3 use of the transmitted tablespace in the physical standby Database You can use the Oracle transportable tablespaces feature to move a subset of an Oracle database and plug

Using rman for cross-database and cross-server migration10g server: 192.168.182.20.oracle 10.2.0.1.0 RHEL 4 32bit 11g Server:Server 192.168.182.131 OEL5.8 _ 32 Oracle 11.2.0.1.0 32bit[Oracle @ oelr5u8-1 admin] $ uname-Linux oelr5u8-1.localdomain 2.6.

I installed the Mongodb database in Ubuntu 13.10. Now I want to write down the installation method and the automatic start method: 1. apt-get update Software Library 2. apt-get install mongodb 3. After installation, You need to modify the relevant

Security is a critical consideration for information systems. According to the widespread attention caused by the explosion of information and data leakage in the world in recent years, without data security, there is no sustained trust from