Monday, October 25, 2010

Almighty Media Center: J. River Media Center



Since Microsoft's proposed "media center" concept since the majority of computer users is very long for the media center computer. But the "media center" needs a number of hardware support, we want to enter the lives of ordinary users will take some time. However, the author described by J. River Media Center software, and you be the first to experience the charm of a media center. J. River Media Center is not just a show, and it is a set of audio and video playback, recording, format conversion, burn, music, podcasts, etc. in an all-powerful media center software.

Media Library for

Install the software wizard will pop up a dialog box, asked to choose an interface, select a good point after the "Next" and then will ask the associated configuration files, according to their needs can be. Open the program first will be prompted to search your computer for media files, click the "Advanced (Advanced)" button can be more specific options (Figure 1), then click the "Start Search (Start Search)" button, wait a moment , a complete media center was born.



Figure 1 set up media library

Gorgeous rich interface

After the completion of the establishment media library, a complete system interface to be displayed in front of a (Figure 2).



Figure 2 J. River Media Center's main interface (+ Click on map to enlarge)

If you think this interface does not look good, click on "Tools / Skins" can change the skin. Do not think that J. River Media Center can play this little game skins, it can completely change the user interface. Click the "View / Theater View (Theater Interface)", look, a new mode of operation will appear (Figure 3), simple and intuitive. Click the "View / Mini View (mini-interface)," you can switch to a mini-interface, and even can set it to non-transparent activities show that listening to music while working on independently of each other has.



Figure 3 J. River Media Center theater mode


[Next]




Powerful

J. River Media Center as a Media Center software, in addition to support multiple media formats to facilitate the management of classified and watch a variety of media formats, it also has many other features.

Recording: Windows comes with the recording tools are too simple, such as chicken ribs. The J. River Media Center is more practical, click on "Tool / Advanced Tool / Record Sound" recording tools can be transferred out, click the "Start (Start)" button to record a. Preservation format for recording, recording quality, output path, recording equipment, audio and other is adjustable, click on "Options (option)" button, you can see the corresponding set.

Copy CD Music: J. River Media Center can encode MP3 or CD music Windows Media Audio format media files. First insert the CD disc, and then "Action Windws (action window)," column, click "Rip CD (recorded CD)", then click "Rip" to start conversion copied.

Format conversion: different music formats for different purposes, so the conversion between formats is unavoidable. First, from the play list or media library to select an audio file, then click on "Tools / Advanced Tools / Convert Format (format)" Conversion dialog box appears, its support for WMV, WMA, MP3, APE, WAV and OGG, etc. Several format.

Music Editor: Click "Tools / Advanced Tools / Media Editor (Media Editor)" to open media editing tool, open a music file can be adjusted to their corresponding (Figure 4).



Figure 4 audio editing

Due to space reasons, J. River Media Center's other features, such as the installation of TV card to watch TV, build internet radio, music, podcasts, CD burning, etc. This will not go into details, and interested friends can explore their own.







Recommended links:



New Year's gift wish Beijing won three Business awards to



Totem Under Ubuntu Sound Problem Playing Rmvb



MOV to iPod



Project cost management cost control of internal



Reference Tools Shop



VC + + dynamic link LIBRARY (DLL) program in layman's language (1)



Dalian International Maritime Expo 2006 Conference reports



Who will be the Chinese MSN portal "murder"



Articles about Remote Computing



7 Steps to escort your USB device



3G2 to MPEG



Fireworks of matting Kung Fu Article



Softbank and IDG withdraw money than the VC who is the next cash cow



VOB To SWF



Monday, October 18, 2010

On implementation of the "two-dimensional bar code" to purchase food consumer confidence


Vegetables, fruit on the fertilizer, excessive pesticide residues is widespread concern that a problem. Today, the Japanese launched a "two-dimensional bar code" that allows consumers to be aware of when buying food.

Ito health is one of Japan's Ibaraki Prefecture farmer, his major supplier of tomatoes grown in the city's supermarkets. Every day, dishes finished, apart from farm work, Ito and health records must be carefully done, detailed note of what is used during planting of pesticides and the use of the frequency and dosage.

Tomatoes mature time to market, Ito health records put all the information uploaded to the "web directory of agricultural products, Ibaraki Prefecture," the website, so consumers will be able to through the food packaging bar codes to understand all the food to match information.

The whole operation is very simple, with consumers only with a camera phone, and download the software, when in the selection of food as long as the bar code scanning using a mobile phone can connect directly to the "web directory Ibaraki Agricultural Products" website , browse and food-related text and image information.

If consumers did not bring camera phones, you can also visit "web directory Ibaraki Agricultural Products" website, enter the barcode number on the same information to understand the product.

"Two-dimensional bar code" come out, make product information more transparent, giving consumers convenient, growers of agricultural products can also play a supervisory role, forming a virtuous circle.






Recommended links:



Zhang Lijun: Hundred Days made hundreds of millions of wealth



Waterproof Wall - Terminology to explain



Learn office 2010 installed a new bulk



Visual Basic To Create "five Star" Level Control



3GP To MOV



Specialist Food And Drink



Mr. Chen: To Gamble, It Is Worth Doing The Business Of Life



To work without SELECTION, the problem you thought about it?



51.com Tencent moved the cake



Shop REGISTRY Tools



AVI to FLV



MP4 To WMP



"Torch Light," Master-class value attached to vocational skills LEARNED over



Monday, October 11, 2010

FreeBSD simple coding


crypt
Coding coding ago:



Code: crpty encoded file name
Input: code key (in this case I entered 123456)



Encoded:

Description: The encoded file content, it should not be read to understand instead.



crypt decoder
Decoding: crpty encoded file name
Input: the original code key (enter 123456)
After decoding: Note: You can see the decoded before file.orig file.aftercode content and coding is the same.



enigma code
Crypt crypt just the same way to enigma, decoding likewise.

Note:
Reusable code, that is, the encoded file re-encoding, key can also be different. Just repeat the encoding, decoding, also need to be repeated in the decoding.
Note: Usually, after encoding the original file will delete ... If not ... why should encoding ..@@"






Recommended links:



ASF to MPG



MP4 to WMP



MKV TO WMV



Chkdsk tool can not fix damaged fat32 boot sector



Wednesday, September 29, 2010

To clarify the status table and table space



DB2 table and table space states use to control access to data, or help protect the integrity of the database. This article describes these conditions and to work examples, demonstrating the emergence of these states typically respond to their conditions and how. Currently, IBM? DB2? Universal Database? (DB2 UDB) support at least 25 kinds of table or table space state. In some cases, these states are used to control access to data, or if necessary, be used to lead to a specific user actions to protect the integrity of the database. With a majority of state resulting from the operation of DB2 utilities related events, such as load utility, or backup and restore utility.

This article describes each of the supported table or table space state (see Table 1; click the state name Skip to the description, the description of a table in the back). This article also provides some working examples to show exactly how to interpret and respond to management of the state of the database may encounter. These examples taken from AIX? Run command script; you can copy, paste and run them in person. If you are non-UNIX? The system running DB2 UDB, please ensure that all of the path name is correct format for the system. Most examples are based on tables in the SAMPLE database, based on the DB2 UDB database is included. There are a few SAMPLE database need not include the scene of the situation, however, you can connect to the SAMPLE database, used as a starting point.

Table 2 and Table 3 describes these states. Table 2 describes the supported table space state, while Table 3 describes the current state of support for the table.

Table 1. To version 8.1.4 until all supported versions of DB2 UDB tables and table spaces defined in state

State the scope of the scope of state

Backup Pending table space tablespace Quiesced Update

Backup in Progress table space Read Access Only Form

Check Pending Table Reorg in Progress table space

DMS Rebalance in Progress table space tablespace Restore Pending

Disable Pending Restore in Progress table space tablespace

Drop Pending table space tablespace Roll Forward Pending

Load Pending Table Roll Forward in Progress table space

Load in Progress table space or table space Storage May be Defined Table

Normal table space or table space Storage Must be Defined Table

Not Load Restartable Table Table Space Creation in Progress table space

Offline and Not Accessible table space Table Space Deletion in Progress table space

Quiesced Exclusive table space Unavailable table

Quiesced Share tablespace

Table space state

db2tbst order to receive the status of the hexadecimal value, and returns the corresponding table space state (see Figure 1). For example, the command returns db2tbst 0x0008 State = Load Pending. The status of the hexadecimal value, in turn, is LIST TABLESPACES part of command output (see Figure 2).

Figure 1. Db2tbst order to receive hexadecimal table space state value and return its status.






Table space is by a single externally visible state of the hexadecimal value of the sum of the state posed. For example, if the table space state is the Backup Pending and Load in Progress, then the hexadecimal value returned is 0x20020 (0x00020 + 0x20000). In this example, the command db2tbst 0x20020 returned:

State = Backup Pending

+ Load in Progress

Figure 2. You can use the LIST TABLESPACES command connects to the database table space to determine the current state.






Table 2. Supported table space states

State of the sample described in hexadecimal status value

Backup Pending 0x20 in the specified time points (point-in-time) after the table space rollforward operation, or in the implementation of the COPY NO option specified LOAD operation (for the recoverability of the database), the table space is in this state . Using the table space, you must back up the table space (or the entire database). If you do not back up the table space, so the table can only contain a query can not update them. Note: Enable the database roll-forward recovery, you must also back up the database immediately. If logretain database configuration parameter is set to RECOVERY, or userexit database configuration parameter is set to YES, then the database is recoverable. Until such a database on a backup, you can connect to it. Backup, backup_pending database configuration parameter is set to NO. 1. Staff_data.del known to load the input file has the following contents: 11, "Melnyk", 20, "Sales", 10,70000,15000:

update db cfg for sample using logretain recovery;

backup db sample;

connect to sample;

load from staff_data.del of del messages load.msg insert into staff copy no;

update staff set salary = 69000 where id = 11;

2.update db cfg for sample using logretain recovery;

connect to sample;

Backup in Progress 0x800 This is a backup operation only during the interim period before the effective state. Implementation of an online BACKUP DATABASE command:

backup db sample online;

In the implementation of the backup operation, through another session run the following script:

connect to sample;

1.list tablespaces show detail; or

2.get snapshot for tablespaces on sample;

connect reset;

USERSPACE1 return information display, the table space in the Backup in Progress state.

DMS Rebalance in Progress 0x10000000 This is a re-balancing only in the implementation of the data to be effective during the operation of a temporary state. When the space is defined as the database management (DMS) table space to add a new container, or when the expansion of existing container, the data on the possible realignment of the table space. Re-adjustment (Rebalancing) is the section of the table space (extent) from one location to another location, try to maintain the data into a single piece of process. A segment (extent) of space is a container unit (in page units), while a band (stripe) is used for table space level set of cross-section of the container. Known load with large data input files staffdata.del (for example, 20,000 or more records):

connect to sample;

create tablespace ts1 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/ts1c1''1024);

create table newstaff like staff in ts1;

load from staffdata.del of del insert into newstaff nonrecoverable;

alter tablespace ts1 add (file''/ home/melnyk/melnyk/NODE0000/SQL00001/ts1c2''1024);

list tablespaces;

connect reset;

TS1 return information display, the table space in the DMS Rebalance in Progress state.

Disable Pending 0x200 roll in the implementation of the database during operation, the table space may be in this state, but when the end of the first rolling operation, it should not be in the state. When the tablespace offline and the transaction has not been written to the hard disk compensation log records, may trigger this state. The emergence of the table space state and the subsequent disappearance of the state is transparent to users. As the table shows an example of the state space, is beyond the scope of this article.

Drop Pending 0x8000 restart the database, if found in the database of one or more containers in question, then the table space will be in this state. (If the database of the previous session terminates abnormally, such as power outage, you must restart the database.) If the table space is in Drop Pending state, it is no longer available, can be deleted. As the table shows an example of the state space, is beyond the scope of this article.

Load in Progress 0x20000 This is an implementation of only the COPY NO option specified load operation (for recoverable database) when a valid temporary status. Known to load the input file staffdata.del have a lot of data (for example, 20,000 or more records):

update db cfg for sample using logretain recovery;

connect to sample;

load from staffdata.del of del insert into newstaff copy no;

In the implementation of the loading operation, the following script from another session:

connect to sample;

list tablespaces;

connect reset;

Information returned for USERSPACE1 return to the information display, the table space in the Load in Progress (and Backup Pending) state.

Normal 0x0 If the table space is not in any other (unusual) table space state, then the state space on the table for the Normal state. Normal state is the table space was created after the initial state. connect to sample;

create tablespace ts1 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc1''1024);

list tablespaces show detail;

Offline and Not Accessible 0x4000 table space if one or more containers a problem, then the table space is in such condition. Containers may occasionally be renamed, moved or damaged. The problem is corrected, and can be accessed again associated with the table space containers, you can disconnect the database and applications through the connection, then re-connect to the database to eliminate the abnormal state. Or, you can perform an ALTER TABLESPACE statement, specify the SWITCH ONLINE clause to eliminate the table spaces Offline and Not Accessible state, so no need to disconnect the other applications with the database. connect to sample;

create tablespace ts1 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc1''1024);

alter tablespace ts1 add (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc2''1024);

export to st_data.del of del select backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp from staff;

create table stafftemp like staff in ts1;

import from st_data.del of del insert into stafftemp;

connect reset;

Table space containers tsc1 renamed tsc3, and then try to check STAFFTEMP table:

connect to sample;

select backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp from stafftemp;

The query returns SQL0290N (not allowed to access the table space), and TS1 LIST TABLESPACES command returns the status value of 0x4000 (Offline and Not Accessible). Table space container tsc3 again named tsc1. This time, the query will run successfully.

Quiesced Exclusive 0x4 table space when you call silence (quiesce) exclusive application functionality (read or write) to access the table space, the table space is in such condition. You can perform a QUIESCE TABLESPACES FOR TABLE command, put Quiesced Exclusive table space state. In the table space is set to Quiesced Exclusive, make sure it is in Normal state.

connect to sample;

quiesce tablespaces for table staff reset;

quiesce tablespaces for table staff exclusive;

connect reset;

From another session run the following script:

connect to sample;

select backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp from staff where id = 60;

update staff set salary = 50000 where id = 60;

list tablespaces;

connect reset;

Information returned for USERSPACE1 return to the information display, the table space is Quiesced Exclusive state.

Quiesced Share 0x1 table space when you call silence (quiesce) function applications and concurrent applications can read (but not write) to access the table space, the table space is in such condition. You can perform a QUIESCE TABLESPACES FOR TABLE command, the table space explicitly placed Quiesced Share state. In the table space is set to Quiesced Share, make sure it is in Normal state.

connect to sample;

quiesce tablespaces for table staff reset;

quiesce tablespaces for table staff share;

connect reset;

From another session run the following script:

connect to sample;

select backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp from staff where id = 40;

update staff set salary = 50000 where id = 40;

list tablespaces;

connect reset;

USERSPACE1 return information display, the table space is Quiesced Share state.

Quiesced Update 0x2 table space when you call silence (quiesce) function in the application space for exclusive write access to the table, the table space is in such condition. You can perform a QUIESCE TABLESPACES FOR TABLE command, the table space explicitly placed Quiesced Update state. In the table space is set to Quiesced Update, make sure it is in Normal state.

connect to sample;

quiesce tablespaces for table staff reset;

quiesce tablespaces for table staff intent to update;

connect reset;

From another session run the following script:

connect to sample;

select backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp from staff where id = 50;

update staff set salary = 50000 where id = 50;

list tablespaces;

connect reset;

USERSPACE1 return information display, the table space is Quiesced Update state.

Reorg in Progress 0x400 This is a just course of reorganization (reorg) to be effective during the operation of a temporary state. Implementation of a REORG TABLE command:

connect to sample;

reorg table staff;

connect reset;

In the implementation of the restructuring operation, the following script from another session:

connect to sample;

1.list tablespaces show detail; or

2.get snapshot for tablespaces on sample;

connect reset;

USERSPACE1 return information display, the table space is Reorg in Progress state. NOTE: SAMPLE database tables involved in reorganization of operations is likely within a very short time to complete, so use this method to observe the Reorg in Progress state may be more difficult.

Restore Pending 0x100 in the implementation of the redirected restore operation after the first part (that is issued before the SET TABLESPACE CONTAINERS command), the database table space is in such condition. Before using the table space, table space must be restored (or the entire database). Until the successful completion of recovery operations, you can connect to the database at this time, restore_pending information database configuration parameter is set to NO. When in Storage May be Defined in the first part of the redirected restore operation is completed, all the table spaces will be in Restore Pending state.

Restore in Progress 0x2000 This is a recovery operation only during the implementation of the temporary status to be effective. update db cfg for sample using logretain recovery;

backup db sample;

backup db sample tablespace (userspace1);

Timestamp of the backup image is: 20040611174124

restore db sample tablespace (userspace1) online taken at 20040611174124;

In the implementation of the recovery operation, the following script from another session:

connect to sample;

1.list tablespaces show detail; or

2.get snapshot for tablespaces on sample;

connect reset;

USERSPACE1 return information display, the table space in the Restore in Progress state.

Roll Forward Pending 0x80 restore the database in the recovery operations after the implementation of the table space is in such condition. The use of table space, you must roll the table space (or the entire database). If logretain database configuration parameter is set to RECOVERY, or userexit database configuration parameter is set to YES, then the database is recoverable. Until the roll operation completed successfully, you can activate or connect to the database at this time, rollfwd_pending information database configuration parameter is set to NO. When in the Restore in Progress in the completion of the online table space restore operation, the table space USERSPACE1 in Roll Forward Pending state.

Roll Forward in Progress 0x40 This is a pre-roll only during the operation in the implementation of the temporary status to be effective. Known load with large data input files staffdata.del (for example, 20,000 or more records):

update db cfg for sample using logretain recovery;

backup db sample;

connect to sample;

create tablespace ts1 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/ts1c1''1024);

create table newstaff like staff in ts1;

connect reset;

backup db sample tablespace (ts1) online;

Timestamp of the backup image is: 20040630000715

connect to sample;

load from staffdata.del of del insert into newstaff copy yes to / home / melnyk / backups;

connect reset;

restore db sample tablespace (ts1) online taken at 20040630000715;

rollforward db sample to end of logs and stop tablespace (ts1) online;

When the implementation of the pre-roll operation, the following script from another session:

connect to sample;

1.list tablespaces show detail; or

2.get snapshot for tablespaces on sample;

connect reset;

TS1 return information display, the table space is in Roll Forward in Progress state.

Storage May be Defined 0x2000000 in the implementation of the redirected restore operation after the first part (that is issued before the SET TABLESPACE CONTAINERS command), the database table space is in such condition. backup db sample;

Assumes that the timestamp of the backup image is: 20040613204955

restore db sample taken at 20040613204955 redirect;

list tablespaces;

Information returned by the LIST TABLESPACES command returns the information display, all the table spaces are in Storage May be Defined and Restore Pending state.

Storage Must be Defined 0x1000 recovery operations in the period redirected to the new database, if the omitted set the stage table space containers, or, if you set the table space containers can not be specified during the stage of the container, then the database table space will in this state. After some time a situation occurs, for example, specify an invalid path name, or disk space. backup db sample;

Assumes that the timestamp of the backup image is: 20040613204955.

restore db sample taken at 20040613204955 into mydb redirect;

set tablespace containers for 2 using (path''ts2c1'');

list tablespaces;

LIST TABLESPACES command returns the information display, table space and table space TEMPSPACE1 SYSCATSPACE are in Storage Must be Defined, Storage May be Defined and Restore Pending state. Storage Must be Defined state than in Storage May be Defined state is more important.

Table Space Creation in Progress 0x40000000 This is only the implementation of the create table space to be effective during the operation of the temporary status. connect to sample;

create tablespace ts1 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc1''1024);

create tablespace ts2 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc2''1024);

create tablespace ts3 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc3''1024);

Create table space in the implementation of the operation, the following script from another session:

connect to sample;

1.list tablespaces show detail; or

2.get snapshot for tablespaces on sample;

connect reset;

TS1, TS2 and TS3 return information shown in these table spaces Table Space Creation in Progress state.

Table Space Deletion in Progress 0x20000000 This is a table space only in the implementation of the delete operation to be effective during the interim state. connect to sample;

create tablespace ts1 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc1''1024);

create tablespace ts2 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc2''1024);

create tablespace ts3 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/tsc3''1024);

drop tablespace ts1;

drop tablespace ts2;

drop tablespace ts3;

Remove the table space in the implementation of operation, the following script from another session:

connect to sample;

1.list tablespaces show detail; or

2.get snapshot for tablespaces on sample;

connect reset;

TS1, TS2 and TS3 return information shown in these table spaces Table Space Deletion in Progress state.

琛?state

DB2 UDB Version 8 load utility status by the table (and lock) to gain access to the table, and the implementation of the loading operation to maintain the database consistency. Even if the abnormal termination occurred loading operation, the table state will also be maintained. You can use the LOAD QUERY command (see Figure 3) to determine the status of a particular table. LOAD QUERY command in the run-time checking the status of load operation, and returns the table status. If the loading operation is completed (or abnormal termination), then the command only returns the table status.

Figure 3. You can use the LOAD QUERY command to determine the status of the specified table.






Although the loading operation before the table space is no longer dependent silent (quiesce is a persistent lock), but the Load in Progress table space state in the implementation of the loading operation to prevent backups on the slave table. Load in Progress table space state is different from the Load in Progress table space state: all the loading operations are using the Load in Progress table state, but the COPY NO option specified load operation (against the recoverability of the database) or use the Load in Progress table space state.

A table in several states simultaneously under. For example, if the data included in the definition of the table check constraint in the table, and specify ALLOW READ ACCESS option, then the implementation of the load during operation, the table on in the Check Pending, Load in Progress, and Read Access Only state.

Table 3. By the support of the state table

State description of the sample

Check Pending the definition of a table if the table check constraint, but not yet verify the new data with those already defined compatibility constraints, it is in this state on the table. For example, DB2 load utility is defined as beginning in the table table check constraints on implementation of the loading operation, the state will set the table for the Check Pending state. If you want to restore the Normal state of the table, you need to do a SET INTEGRITY statement. Known to load the input file staff_data.del have the following: 11, "Melnyk", 20, "Sales", 10,70000,15000:

connect to sample;

alter table staff add constraint max_salary check (100000 - salary> 0);

load from staff_data.del of del insert into staff;

load query table staff;

LOAD QUERY command returns the information display, STAFF table is in Check Pending state.

Load Pending before the data can be submitted if the table is performed on abnormal loading operation was terminated, then the table on in this state. To make the table to resume Normal state, you need to call the load terminate, load restart or load replace operation. Known to load the input file staffdata.del with large data (eg, 20000 or more records), create a table that contains a small load operation target table space, create a new table named NEWSTAFF:

connect to sample;

create tablespace ts1 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/ts1c1''256);

create table newstaff like staff in ts1;

load from staffdata.del of del insert into newstaff;

load query table newstaff;

load from staffdata.del of del terminate into newstaff;

load query table newstaff;

connect reset;

LOAD QUERY command returns the information display, NEWSTAFF table in the Load Pending state; in the implementation of the load terminate operation, the the table on the back in the Normal state.

Load in Progress This is a load operation only during the implementation of the temporary status to be effective. Known load with large data input files staffdata.del (for example, 20,000 or more records):

update db cfg for sample using logretain recovery;

backup db sample;

connect to sample;

create table newstaff like staff;

load from staffdata.del of del insert into newstaff copy no;

connect reset;

In the implementation of the loading operation, the following script from another session:

connect to sample;

load query table newstaff;

connect reset;

LOAD QUERY command returns the information display, NEWSTAFF table in the Load in Progress state.

Normal if the table is not in any other (unusual) form the state, then it is in Normal state. Normal state is created after the table is the initial state. connect to sample;

create table newstaff like staff;

load query table newstaff;

LOAD QUERY command returns the information display, NEWSTAFF table in the Normal state.

Not Load Restartable when the execution finished before the rolling operation, followed by the emergence of a failed load operation, and the operation has not been successfully restarted or terminated, the table on in this state. The table will also be in the Load Pending state. To make the table to resume Normal state, you need to execute a LOAD TERMINATE command. Known load with large data input files staffdata.del (for example, 20,000 or more records):

update db cfg for sample using logretain recovery;

backup db sample;

connect to sample;

create tablespace ts1 managed by database using (file''/ home/melnyk/melnyk/NODE0000/SQL00001/ts1c1''256);

create table newstaff like staff in ts1;

connect reset;

backup db sample;

Timestamp of the backup image is: 20040629205935

connect to sample;

load from staffdata.del of del insert into newstaff copy yes to / home / melnyk / backups;

connect reset;

restore db sample taken at 20040629205935;

rollforward db sample to end of logs and stop;

connect to sample;

load query table newstaff;

connect reset;

LOAD QUERY command returns the information display, NEWSTAFF table is Not Load Restartable and Load Pending state.

connect to sample;

load from staffdata.del of del terminate into newstaff copy yes to / home / melnyk / backups;

load query table newstaff;

connect reset;

LOAD QUERY command returns the information display, NEWSTAFF expressed in the state in Normal.

Read Access Only in the implementation of the loading operation, if you specify the ALLOW READ ACCESS option, then the table will in this state. Read Access Only is a temporary state that allows other applications and utilities read access in the implementation of existence before loading the data operation. Known load with large data input files staffdata.del (for example, 20,000 or more records):

connect to sample;

export to st_data.del of del select backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp from staff;

create table newstaff like staff;

import from st_data.del of del insert into newstaff;

load from staffdata.del of del insert into newstaff allow read access;

In the implementation of the loading operation, the following script from another session:

connect to sample;

load query table newstaff;

select backup bin conf config data eshow_sitemap.html generate.sh log maint sitemap.html svn tmp from newstaff;

connect reset;

LOAD QUERY command returns the information display, NEWSTAFF table in the Read Access Only and Load in Progress state. The query returns the contents of export STAFF table, and before the implementation of load operation, there is data in the table in NEWSTAFF.

Unavailable current roll of a load operation can not be restored, the table in this state; this table can only be removed, or from the backup image to restore it. Known to load the input file staff_data.del have the following: 11, "Melnyk", 20, "Sales", 10,70000,15000:

update db cfg for sample using logretain recovery;

backup db sample;

Timestamp of the backup image is: 20040629182012

connect to sample;

load from staff_data.del of del insert into staff nonrecoverable;

connect reset;

restore db sample taken at 20040629182012;

rollforward db sample to end of logs and stop;

connect to sample;

load query table staff;

connect reset;

LOAD QUERY command returns the information display, STAFF sheet is Unavailable state.

Conclusion

DB2 UDB table space with the state and the state table to control access to data, or in specific cases to help protect the integrity of the database. This paper shows examples of work may lead to a specific state of the more common conditions that you can use them to identify which state is effective, and how to properly respond, so you can continue to use the data, without any leakage beat (miss a beat ) phenomenon. You will be very easy to adapt to these examples, and they use their own data; soon, you will truly "perceived around the" various states, and can use them to better understand the behavior of the database.







相关链接:



Lenovo restart willow to break the current mix



Fax Tools Report



Qualcomm CEO: WiMax 3G will compete in the face of setbacks



What is digital TV renovation Project?



The biggest killer of retail sales



Interview Xoceco Xie Siyu: flat panel TV has been REVERSED in the Western pattern



WMV To MPEG



Close to the KM Role



Cursors And Fonts introduction



Source Editors Infomation



Infomation Computer Education



Shanghai real estate control POLICIES introduced Countdown



ASF to MPG



AVI to 3GP



Remodeling "value STREAM"



Friday, September 17, 2010

Common understanding between the main types of disc burning



As the discs manufacturers and different materials used for the recording disc recording layer (also called dye layer) of the material differences also affect the disc's high-speed recording, different players, the compatibility between the disc and burn disc entire life. Even the same manufacturer may use different materials on the market the disc. CD-R market at present a blank CD in the recording layer of organic dye used is divided into three types: Cyanine, Phthalocyanine and AZO. Because these three organic dyes have their own colors, plus the color combination of reflector, will film in the CD-R disc data surface mapping out the different colors. Therefore, we generally different color CD-R discs, known as the green plate, gold plate, blue plate ... .... Because the use of different organic dyes, these CD-R discs in performance and price are different. Following a brief introduction on to tell us the differences between them.

1. Green Disk (Cyanine)

Cyanine by Taiyo Yuden (Taiyo Yuden) invented, is the prototype of the other two materials, materials, after Phthalocyanine and are based on Cyanine improvements AZO formed. In other words, first, Cyanine, and then only Phthalocyanine and AZO.

Cyanine blue as a blue light-sensitive chemicals, and the reflective layer of gold color mixed, will form a dark green in the data plane or blue-green, so as the raw materials used Cyanine CD-R discs known as the green disc. However, the original material is very afraid of Cyanine light, are photosensitive material in the manufacture of synthetic must add appropriate iron metal to reduce the ability of light sensors. Based on dye their defects, a new generation of green light-sensitive material plate strengthened anti-optical, CD film that enhanced the preservation of nature, such as gold plate so as to have a longer shelf life, because raw materials are lighter in color, appearance Condition is very close with the gold plate, so many people call it green gold disk (or silver plate).

Green produced the first disc is a Taiyo Yuden Company, so the launch of That's the green plate, was used as the basic test disc recorder. Means that, if you use That's Green disc burning problem still occurs, then the disk probably is not burning, but burning machine or system problem.

2. Blue plate (AZO)

Verbatim AZO dyes in the early representatives of the company by Verbatim's parent company - Mitsubishi Chemical Corporation (Mitsubishi Chemical Company) is responsible for production. Blue CD-R discs of AZO films by metal organic dye materials with low reflective layer made of silver. As the metal of AZO dye itself dark blue, white and silver reflection layer with the formation of the blue data plane, it is called the blue plate.

Since Mitsubishi Verbatim is a subsidiary of the company invented blue disk, so there is only two of the real blue plate. Early AZO material can only use a single speed or double speed burner, while not successfully used in high-speed (4x or more) of the recorder used. However, when DataLifePlus CD-R discs was published, Verbatim Corporation announced this new formulation of AZO CD-R discs to overcome the speed bottleneck, has been able to 4x burner to use.

3. Gold Disk (Phthalocyanine)

Gold plate is improved by the green disk from the gold plate is generally considered the most advanced CD-R discs. But now the golden plate prices have sharply declined to less money a few, really can be said to be inexpensive. Gold Disk using organic dyes as Phthalocyannine, this organic dye itself is nearly transparent to light yellow, while the use of pure gold reflective layer, reflective layer of gold mixed with the following literacy leaving it cash in yellow. Since the stability of gold plate and plates better than others, and has good read rates, early CD-ROM drive can identify such a smooth disc. So most people get this CD-R discs to back up data.

Produce the first gold disc is Mistui Toatsu (Mitsui) Company, and thus Mistui Toatsu gold plate with a wide range of users. And Mitsui have to do someone else's OEM disk, like the early Kodak, HP, Philips gold plate are Mitsui do. In addition, Kodak's Gold Disk also "Infoguard" patent technology, which is coated with a layer of the top disc special material to better protect the discs from corrosion and oxidation. However, because the cost of gold plate is too expensive, so fewer and fewer companies in the production, and manufacture of such discs manufacturers are only Mitsui Toatsu and Kodak, even such a giant Kodak has also started to give up the production of gold plate.

Phthalocyanine dye has better resistance than the light of Cyanine, also has high stability, is a CD-R to save the oldest one. After a long period of preservation are not easily generated mutation, so manufacturers have to publicize the data storage of up to a century masterpiece.

4. Platinum disk (Phthalocyanine)

In fact, the so-called platinum disc, there are no platinum, no gold, just a little white in color with gold. It is used as dye and gold plate is Phthalocyanine, but the use of silver as reflective layer, such as platinum color will show. Platinum plate and gold plate is very close to nature, preserve a long time, good compatibility with the recorder, cheap. Several integrated features above, you can know that can not afford to use one gold plate, platinum plate is a good choice, generally take platinum disk backup data are, of course, was brought carved VCD, this of course can only be to see how the use of individuals only.

Currently, many manufacturers made the long drive platinum disc, such as our common 700MB, or 800MB of CD-R, CD-ROM for the average family that some of the data backup, network, download a small program should be enough.

5. Ocean blue plate (Cyanine)

Since there is a real blue plate, the latest on the market should drive it more often see the ocean blue! Ocean blue and green disc set is the same as organic dyes are Cyanine, but the reflection layer to switch to silver, so it also became a combination of a light blue plate. The reflective layer from the gold into silver while the birth of ocean blue plate, the biggest advantage is lower prices, after all, gold is still more expensive than silver. Nevertheless, freshwater blue disc compatibility is very good, in fact we now see is that the majority of Blu-ray disc drive.

To facilitate the convenience of you remember, we have listed the following formula:
* Set = gold reflective layer green + blue blue Cyanine dye
* Ocean blue silver reflector disc = blue Cyanine + blue dye
* Gold plate + yellow = gold reflective layer of Phthalocyanine dye
* Platinum Silver reflector disc = light yellow Phthalocyanine dye +
* Blue = silver reflector disc + dark blue AZO dye

Miu Miu posted: CD-RW discs and CD-R discs is slightly different, CD-R disc's recording layer is a film of organic dyes used, the CDRW is used in a different material. Such material is made from silver, antimony, tellurium, indium metal film composed of a variety of metals. This material has two kinds of crystalline and amorphous state, these two states to the laser reflectivity is very different. Crystalline and amorphous as changes in the state belong to the physical changes, you can revert to a previous state, it can be repeated to write the same location. However, because current technology conditions, it can erase about 1000 or so.







Recommended links:



Intermediate Hospital "backward" Sample



How To Identify Real And Can Automatically Create Index Index



Using warm and intimate small music prompted the fish that You're familiar with the music fish



Operators Tangle: 3G What Is The Best Billing



A record of random Access Recordset



Flv To Divx



Jia Peng Lei: "diversity" denatured



ipod touch video format



Compare Games AND Entertainment



Three Anti-monopoly Law Enforcement Departments, Year Introduced Several New Deal Soon



Ps3 Mts



Brief Audio And Multimedia



Top Shell Tools



Wmv files



Small Window, Big World Comparative Evaluation Pocket PC 8



CSI Financial Dialogue Sina CEO Qu Xiao-Hua, founder Artus Record



Tuesday, August 3, 2010

PPS quietly started charging, the industry doubt who is willing to pay?



Some careful PPS Network TV users has found that each time you open the client will be reminded to register or login, the login and click enter, it will easily jump to the PPS-VIP Member page, the page to promote the VIP membership privileges and the main function, together with details of opening and membership fees: Silver Member 10 yuan / month free advertising, Gold Member 20 yuan / month free ad and upload the default choice for six months from the payment. I carefully study found that members of its exclusive promotional "free advertising" means to "not waste a second time for the annoying ads, launched PPS-VIP members are enjoying the privilege of skipping video ads" as a selling point. This desire is certainly good, but also will lead to the industry of a doubt - who is willing to foot the bill?






As we all know, the current domestic video sites, either potatoes, Youku like video sharing, or PPS, PPLive like P2P, are currently free, which not only has the video industry's consistent practice is the emerging Chinese Internet start at the beginning of a great enterprise "features." From the user level, through the network for free to watch online video content anytime, anywhere, no doubt attracted their attention from traditional media to attract over a major reason, which is favored by the new media advertisers the most direct incentives .

The current structure of the Internet business is basically built around the ad's. Free patterns web site is doomed to advertisers as the first center, not end users. The ad has a "clustering" feature, advertisers generally value the most popular, best portal, while the other wants from Fengeng site, you must have a lot of hits and users. Network video media from the brand currently has relied on advertiser's point of view, the main screen buffer and commercials undoubtedly be the most valued of the launch of its position, if the network screen video playback software, the "annoying advertising," then why do advertisers We should continue to foot the bill? online video media, how to brand advertisers to provide authentic and have put the value of the ad click rate?

Of course, to the reality of survival or profit targets, under the concept of free web advertising model is only applicable to a large minority of users, click on high-level portal site, not to feed the entire Internet industry. Find other activities, monthly fee the first to. But at this stage, the Chinese Internet companies hundreds of millions of Internet users can not really provide very personalized, high quality innovative services, video web portal is not yet equipped to contend with the size of the audience, advocating charging culture, it really will speed up the video site the profitability of the process it? PPS fees, the goal is to realize a fast profit, or due to pre-bandwidth, high cost of a novelty factor of copyright?

Foundation of China's Internet culture inherent charge, but life is not without charging the soil. In fact, the original Internet bubble into the plight of the time out to help the plight of the main website is not online advertising, but the seemingly humble SMS value-added service charges. Facts have proved that Internet users pay to get rich is not "mission impossible." The point is that Internet companies can provide value for money, no substitute for high viscosity service, if not to provide innovative, "killer" application, the face of China has accumulated rich Internet free culture in the early development of the industry, If users and advertisers are reluctant to foot the bill, it is difficult to imagine, PPS will be a fraction of charging the odds.







Recommended links:



DreamwaverMX and ASP.NET (1)



audio to Mp3 converter



Soft-Bo At the three prediction



Fireworks 8 dream trip (5): the new changes in the menu



google VIDEO format



ts FILE



Articles About Multimedia Creation Tools



Recommend Audio Recorders



GAMES Card Catalogs



FreeBSD dnstracer command description



Wma Converter



Junk mail in orders



Easily CREATE bar codes



Wang Quanguo: to "King Kong" solid as a rock



Modify the TCP / IP After so fast you do not believe



Wednesday, July 21, 2010

Unicom iPhone pricing and the new packages have all been questioned



China Unicom [6.49 -0.61%] 14, announced on October 30 will be sold in China, iPhone 3G and iPhone 3GS mobile phones, and published the iPhone bare metal prices. At the end of September launch commercial 3G network, China Unicom has announced the development of mobile phone users for the iPhone "iPhone24-month contract plan."

China Unicom said that if the user to participate in "iPhone24 month contract plan" to buy iPhone 3GS 16GB mobile phones, pay 3,999 yuan and 3,000 yuan stored charge, select the package 126 yuan monthly fee, the future network of 24 months, monthly will be returned to its 125 this prognosis. Thus, if the business does not exceed the use of the agreed package amount, a month prognosis, only pay 1.

China Unicom announced iPhone bare metal prices: iPhone 3G 8GB price of 4999 yuan, iPhone 3GS 16GB price is 5880 yuan, iPhone 3GS 32GB price is 6999 yuan.

But the reporter visited the parallel market, found that China Unicom bare metal version of the iPhone gray market price at least higher than the price of 1,000 yuan. To 16GB iPhone 3GS, for example, China Unicom announced bare metal price 5880 yuan, and do not have WIFI function, while Zhongguancun [5.60 -0.18%] gray market is only 4,800 yuan, with WIFI function.

Golden State Securities [20.80 -0.29%] Chen Yun-hong analysts believe that the reason for the high pricing bare metal, bare metal China Unicom is to raise the threshold to attract more users into the package. But the bare metal prices more expensive than the gray market will restrain consumer demand part.

China Unicom Chairman Chang Xiaobing said: "very pleased to recently introduced iPhone, and provide customers with a wide selection of 'iPhone24 a contract plan'."

However, Chen Yun-hong that Unicom "stored Hua Fei" the package model prone to consumer resentment, which may affect the iPhone 3G on Unicom to snatch the effect of high-end customers.

Unicom insiders have told reporters, "China Unicom senior currently on the market reaction to a high degree of tension on the iPhone. Unicom also suggested that after the internal design of the iPhone package does not meet local consumer spending habits. But how to adjust the specific package remains to be further refinement. "

Unicom version of the iPhone to the market's acceptance of China Unicom to provide the data inside: The "11" golden weeks 8 days, with China Unicom 3G wave of official business, online business hall Unicom first iPhone (Mobile Internet) Booking break 10,000.

But who asked not to be named, told reporters the industry, the Department of thousands or tens of thousands of reservations iPhone useless for Unicom, the magnitude of at least a few 100,000 to be helpful on Unicom.







Recommended links:



convert flac To mp3



Youtube FLV To MPG Store



WorldCup 3GP Converter



ASP.net (C #) Bulk Upload



Format Blackberry



Bluesea DVD to WMV



Astronomy Wizard



Aya iPod iPhone APPLETV Video Converter



JSN-1 (A) Digital Switching Introduction



Hope DVD to FLV



how TO convert avi to wmv



Vacations VCD to DVD



Easy to use Adventure And Roleplay



Aac To Mp3 Converter



Christmasgift Mobile Converter



Review Cursors And Fonts