1. You should use the Informix account to manage the database, such as Grant/revoke permissions, creating/deleting tables, dbload, and so on.
2. Should you create a separate account to do these things? Why?
3. Should you use the Informix account to manage the database application and place all users in this group?
Instead of doing everything with the
Brief introduction
The recently released 32-bit Informix client-sdk for the Mac OS X platform provides improved Open Database connectivity (ODBC) capabilities to seamlessly integrate an ODBC-aware application with Informix D Ynamic Server (IDS) integrated.
ODBC drivers are available in two forms on Mac OS X, dynamic libraries and application plug-ins. Developers who call the ODBC API directly through an a
GRANT authorization, grant authorization
Log On As the sys (Administrator) and create the username zsta_new
Create user zsta_newIdentified by passwordDefault tablespace ZSTA_DATA_TBSTemporary tablespace TEMPProfile DEFAULT;
Authorize zsta_new users (allow creation of stored procedures, etc ):Grant connect to zsta_new;Grant
Improve concurrency and locks so that more users can access data faster.From the Chinese version of IBM database magazine.
A very important but often overlooked Performance Tuning step is to check how Informix Dynamic Server (IDS) handles locks and concurrency. In my advanced Informix Performance Tuning course, tuning locks are one of the five important steps to improve performance.
Number of locks
Improve concurrency and locks, allowing more users to access data faster.
From IBM Database Magazine Chinese version.
One important, but often overlooked, performance tuning step is to check how Informix Dynamic Server (IDS) handles locks and concurrency. In the Advanced Informix Performance Tuning course that I teach, tuning locks is one of the five important steps to improve performance.
Number of Locks
W
In linux, add users and grant root permissions. in linux, grant root permissions.1. Add a user. First, use the adduser command to add a common user. The command is as follows:# Adduser tommy// Add a user named tommy# Passwd tommy // change the passwordChanging password for user tommy.New UNIX password: // enter the New password hereRetype new UNIX password: // enter the new password againPasswd: all authent
omitted.Run oninit to test whether the instance is started successfully.Use the onmode-ky command to test whether the function is disabled successfully)
3. Create a database spaceRun when the database is not started$ Onspaces-c-d cifdbs-p "/bank/informix/data/cifdbs"-o 100-s 512000$ Onspaces-c-d migdbs-p "/bank/informix/data/migdbs"-o 100-s 1024000$ Onspaces-c-d cmsdbs-p "/bank/
Known: The test user tuser1, the test role trole1, and trole1 have been authorized to tuser1.
Latency is required for testing a program, so dbms_lock is authorized to trole1 and put in an anonymous block for testing:
SQL> set serveroutput on;
But an error is returned when you move it to the function:
Connected to Oracle Database 11g Enterprise Edition Release 11.2.0.1.0
It is strange that dbms_lock cannot be used in the function. Google it to find the answer:
You must
Operating System: Red Hat Enterprise LinuxServer release 5.5
Informix version: Informix_Ultimate_11.70.UC3_LIN_x86_32_FixPack.tar
Write the local IP address and hostname to/etc/hosts.
1. Create informix users and groups
[Root @ informix ~] # Groupadd-g 1000 informix
[Root @ informi
1. Create an Informix group and an Informix userUse the root user to pass the Informix Installation File to LinuxUse the root user to install Informix in the/bank/informi directory
2. Use Informix to configure the installation.Modify the/bank/
This article assumes that the use of Informix starts from scratch, and describes the detailed steps for maximizing the use of Informix from scratch. Note: The content about VI editing in this article is placed between the equal signs of two rows. You need to edit and save the disk.
1. Download the Informix-Online Database Server Linux Trial System
Address: http:
This article assumes that everyone's use of informix starts from scratch, and will introduce the detailed steps from zero to maximize use of informix.
The content of vi editing in this article is placed between two lines of equal signs.You must save it after editing.
1: Download the informix-online database server LINUX trial system
Address: http://www.intrawar
This article assumes that the use of informix starts from scratch, and describes the detailed steps for maximizing the use of informix from scratch. Note: The content about vi editing in this article is placed between the equal signs of two rows. You need to edit and save the disk.
1. Download the informix-online Database Server LINUX Trial System
Address: http:/
The Informix Dynamic Server provides two levels of access privileges to ensure database security. Database privileges control the access to the database and the right to create tables and indexes on the database. TABLE privileges specify the actions that a user can perform on a specific table.
The Informix Dynamic Server supports table-level modification, insertion, and deletion security, while enhancing co
1. Pre-Installation Preparation
1) need to install Turbolinux products
2 need to have installation files ids.rpm, connect.rpm and clisdk.rpm
ids.rpm Informix Dynamic Server 7.3
CONNECT.RPM Informix Client Product Connectivity Environment
CLISDK.RPM Informix Client Product development environment
3 need to have legal serial number and Key number
4 If more t
Informix has always been relatively unavailable. Due to a project relationship, it has to be installed and used. Previously, it was mainly used for Oracle. This installation of Informix was also the first one.
I. Prepare MediaRedHat Linux as 4 has four disks, which can be downloaded from the Internet. Informix 9.40uc9 is a tar file and does not compress around
Informix IDS databases are widely used in various industries such as finance, telecommunications, and postal services. It is a multi-threaded relational database server that adopts symmetric multi-processor technology and single-processor architecture, it also has advanced technologies, performance, high reliability and high availability. It provides users with dynamic system management tools to monitor and manage database servers. As the number of da
First, of course we need to obtain the installation package of the Informix database. The installation packages are different for different systems. In fact, the basic installation steps are similar.1. Obtain the installation package of the Informix database and upload it to a directory in the system.2. Create an Informix group and an
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.