unix
Advertisements
Recently used the h2 database project, encountered some problems on the Internet to find the answer always felt inappropriate to summarize the problems a bit. 1.h2 WINDOW and UNIX in the use of the above WINDOW above on the use of official documents
Find TCP / IP Service Name db2 get dbm cfg | grep SVCENAME Get output TCP/IP Service name (SVCENAME) = db2_dch In the / etc / services file to find the port number grep db2_dch /etc/services Get output db2_dch 60000/tcp Db2 database which 60000 is th
String sql = "SELECT w.work_id, w.room_id, rm.name, CAST (sec_to_time (sum (unix_timestamp (statusTime.end_time)-unix_timestamp (statusTime.create_time))) as CHAR) as times" + ", W.number, statusTime.create_time, statusTime.end_time FR
Soft reference command: ln-s / ** / / ** / Add write permissions: chmod a + w / file
Today, let me call my colleagues in the database under a user to export all the comment by the relevant building related sql function to achieve the following: 1. Log on to a remote server sqlplus tbs/xxxx@198.120.1.1/ticket 2. Set various parameters
Few people may realize, in a process calls exit after the process was not immediately disappear, but leave a zombie process called (Zombie) data structure. In Linux process five states, the zombie process is a very special one, it has given up almost
1.bzero function bzero equivalent to memset (void * str, 0, size_t n) 2.inet_pton function inet_pton the dotted decimal IP address into network byte order of address, such as inet_pton (AF_INET, "202.182.0.25", & servaddr.sin_addr) 3.ti
http://www.chinaunix.net Author: sdccf at :2004 -01-09 10:42:16 Command name: chmod Access: All users use: chmod [-cfvR] [- help] [- version] mode file ... Description: Linux / Unix file permissions is called into three groups: the file owner, group,
In the Cooperative Office in a custom form web development tool is the core component , It can provide data to show the system for collaborative interfaces, development tools, custom forms and return by calling the interface to receive data displayed
First, the parameter file and server parameter file parameter file (Parameter File) are usually referred to as the initial file (init file), or the init.ora file. The default name is init <ORACLE_SID>. Ora text file. SPFILE generate PFILE: crea
Original link: http://blog.163.com/jack0220 @ 126/blog/static/5618620420093225183543 / Ant is a Java-based build tool. In theory, it is similar to (Unix) C in the make, but did not make the defects. Now that we have make, gnumake, nmake, jam and why
Very often, we write code, is used in wndows vc write the following, but it needs to linux system or compile on other unix systems, also need to also write the makefile too much trouble following this tool, you can read directly from the vcproj files
How to set up crontab in a way to perform the last day of each month: for Linux 0 8 28-31 * * [`date-d tomorrow + \% e`-eq 1] & & (shell script) for other Unix, BSD 0 8 28-31 * * [`echo \` cal \ `| awk '{print $ NF}'`-eq 1] &
RT Needless to say, peer-to see that! MySQL Partitioning There are many, here I only discuss a time - by day partition! Before the operation, you still need to execute the following command, check your MySQL version supports partition functions: show
You can use mysqldump backup tool. Time, you can use the windows scheduled tasks or linux / unix's crontab http://dev.mysql.com/doc/refman/5.1/zh/database-administration.html # disaster-prevention You can refer to the official manual of examples
Online to find the arrow keys to solve the problem vi, there are several ways to find a following, and have highlighted ways. Under the Ubuntu Linux does not seem to be the default language for programming highlights, but you can set up their own to
Continue my open-source journey. Today is installed FreeBSD8.2. From FreeBSD's official website to download the latest iso. Telecom's network is to force it, half an hour to download over an average speed of 700K / s: P Booting from CD, look
In order to provide the operating system CPU utilization, the introduction of multi-channel programming, so there is the concept of the process. Process model will undoubtedly improve CPU utilization, because multiple processes can "simultaneous
patch remove Bomb (^ M) $ cat ~/bin/rmBom #! /bin/sh¬ ¬ #echo "uconv --remove-signature the $1 files"¬ ¬ ### uconv not availble¬ # find . -name "*.$1" \¬ # -exec uconv --remove-signature {} -o {}.nobom \; \¬ # -exec mv {}.nobom {} \;¬ ¬ ### ¬ # Conve
Database name, instance name, database name, global database name, service name, These are a few confusing to many beginners concept. I believe a lot of beginners like me to be the title with a concept and made a loss on these. Let us now get hold of
add permissions for the current directory linux chmod 777 *.* Original: http://linux.chinaunix.net/techdoc/system/2007/12/11/974135.shtml the linux chmod, chown command Detailed Source: ChinaUnix blog Date: 2007.12.11 09:48 (Total comment) I want to
http://www.docin.com/p-237128610.html 2011-09-20 1.
Some versions of Ubuntu are hidden super-user, but many places have to use the super-user privileges. We can set super user: ... ...: ~ $ Sudo passwd Password: -> enter that user's password during installation Enter new UNIX password: -> Ne
If you can easily make the shell prompt and become colorful leadership of the party with more information, why persist with the monotonous standard shell prompt them? In this tip, Daniel Robbins will show you how to get in line with the wishes of the
Unix Programming Environment
Advanced UNIX programming code package
Error 1: ERROR 2003 ================================================== ==================== Symptom: Can not connect mysql Error message: ERROR 2003 (HY000): Can't connect to MySQL server on 'hostxxxxx' (10061) Reasons: mysqld does not st
Reproduced: http://www.ibm.com/developerworks/cn/aix/library/au-lsof.html In the UNIX ® environment, the files everywhere, which have given rise to the motto: "everything is a file." Files can be accessed only through conventional data, typicall
yum install vsftpd 2 start / restart / shut down vsftpd server [Root @ localhost ftp] # / sbin / service vsftpd restart Shutting down vsftpd: [OK] Starting vsftpd for vsftpd: [OK] OK indicates that the restart was successful. Startup and shutdown wer
Bash environment setting and documents related to / Etc / profile (main) $ HOME / .bash_profile (main) $ HOME / .bash_login $ HOME / .profile $ HOME / .bash_logout (main) $ HOME / .bashrc (main) / Etc / bashrc As follows: Login (login) when First run
Oracle table space the size of the view method should we need to know the following details on See you space the size of the Oracle table for your reference study. In database management, disk space is a DBA will encounter the problem, the problem is
Real Application Cluster (RAC) is a Component of the Oracle 9i Database Product that Allows a Database to be installed across multiple Server S. According to Oracle, RAC's shared disk method of Clustering Databases: INCREASES scalability because
Stored procedure: CREATE PROCEDURE `ClearCoupon`() BEGIN declare today int(16); select UNIX_TIMESTAMP(curdate()) into today; UPDATE coupon SET status=0 WHERE endtime<today; END; copy to the inside phpmyadmin executed on the error Error SQL query:
Oracle tables are locked treatment: 1. oracle Check whether the table is locked in Check whether the table is locked SELECT /*+ rule*/ a.sid, b.owner, object_name, object_type FROM v$lock a, all_objects b WHERE TYPE = 'TM' and a.id1 = b.object_id; 2.
Two date / time difference between the number of days: SELECT To_Days (end_time) - To_Days (start_time); Two date / time difference in hours between the number of seconds: SELECT SEC_TO_TIME (UNIX_TIMESTAMP (end_time) - UNIX_TIMESTAMP (start_time));
Compile and install MySQL 5.5.13 Previously have not installed and with great effort Compile and install MySQL 5.5.13 Build mysql installation directory and data storage directory # mkdir /usr/local/mysql # mkdir /usr/local/mysql/data # mkdir /usr/lo
1: in a terminal: mysql-V Here is the code snippet: [Shengting @ login ~] $ mysql-V mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686) 2: in mysql: mysql> status Here is the code snippet: mysql> status; -------------- mysql Ver 14.7 Di
I. Creating SPFILE Default, ORACLE database using the PFILE startup, SPFILE from the PFILE must be created, the newly created SPFILE Take effect the next time you start the database, CREATE SPFILE need SYSDBA or SYSOPER privileges: Syntax is as follo
In our application development time is very common, most of the development we will use the mysql datetime format to store, but often it takes time to sort or query applications, we want to make the time index, just check the efficiency of our great
1: in a terminal: mysql-V. Here is the code snippet: [Shengting @ login ~] $ mysql-V mysql Ver 14.7 Distrib 4.1.10a, for redhat-linux-gnu (i686) 2: in mysql: mysql> status; Here is the code snippet: mysql> status; -------------- mysql Ver 14.7
innodb_flush_log_at_trx_commit: The main control of the innodb log buffer data to the log file and flush the disk write time point, values were 0, 1, 2 three. 0, when the transaction commits, not to write the log, but second in the log buffer data
First, what is the database name database name? Database name is a database of identity, as the same person's ID number. Parameter DB_NAME he said, if a machine upload multiple databases, then each database has a database name. Or created in the
mysql unix like systems the default is case-sensitive table names can be set in the startup script so that it is not case sensitive Modify / etc / mysql / my.cnf In the [mysqld] add lower_case_table_names = 1 under Restart mysql Mysql default under t
1 to date to timestamp SELECT UNIX_TIMESTAMP ('2011-01-26 ') Results: 1,295,971,200 (2) to the time stamp type SELECT FROM_UNIXTIME ('1295971200 ') Results :2011 -01-26 12:00:00 AM 3 as the date for the timestamp type select date (FRO
Two date / time difference between the number of days: SELECT To_Days (end_time) - To_Days (start_time); Two date / time difference in hours between the number of seconds: SELECT SEC_TO_TIME (UNIX_TIMESTAMP (end_time) - UNIX_TIMESTAMP (start_time));
Detailed: database name, instance name, ORACLE_SID, database name, global database name, service name -------------------------------------------------- - Database name, instance name, database name, global database name, service name, Many beginners make
1: in a terminal: mysql-V. Here is the code snippet: [Shengting @ login ~] $ mysql-V mysql Ver 14.14 Distrib 5.1.49, for redhat-linux-gnu (i686) using readline 5.1 2: in mysql: mysql> status; mysql> status -------------- mysql Ver 14.14 Distrib
mongoDB is Nosql database, operational data in a format similar to json. Study documents the http://www.mongodb.org/display/DOCS/Quickstart+Unix Further study see: http://www.mongodb.org/display/DOCS/Tutorial Note: Start to enter the unpacked directo
Delete the database user will be reported when there is a connection but does not allow users to delete database 1, there is the following statement queries the connection: select sid serial #, process from v $ session; 2, kill the connection: alter
Find more information on the N line, no one can smooth and successful, depressed, may be limited level of it ...! I through continuous research, testing, full implementation of the linux start two Mysql, but also a deeper understanding of mysql ... ado, w
