The current situation is that the Sybase Database has been installed. You need to create a new PTMs database and specify a username Sybase/Sybase, with all roles and permissions, you must specify the load when creating the database.
Start-all programs-Sybase-dsedit utility. The following page is displayed:
Click "OK". The following page is displayed.
These servers are installed by default. Next we will add a new server. Right-click in the blank area of the "server" box and choose "add" to enter a server name, I enter "PTMs" and click "OK"
Double-click "server address" on the right side. The dialog box is displayed.
Click "add", select "TCP" in the Protocol drop-down list, enter the IP address and port number (5000) of the local machine, OK, OK, and disable
Start the Sybase server, go to the ASE-12_5/install directory under the Sybase installation directory, and run _ computer name. BAT file. As mentioned earlier, the default server name is the computer name. I am running the run_icesoft.bat file.
Server startup complete
Start-all programs-Sybase Central Java Edition
Go to the main interface
Click "link" in the shortcut, the logo of the computer in the figure, the default user name "sa", the password is empty, select the server "PTMs" created earlier in the drop-down list, click OK
After the connection is successful, you will find the database view on the left.
Right-click "PTMs (SA)-databases-master" and click the "devices" tab. Then, click the "add" button.
Select transaction log and master, and fill in number smaller than the remaining space (17 MB) in size. I fill in 15, for unknown reasons, this is because I don't set it here when I use the extended database space later, so I am not familiar with it. I will try it out first! Click OK again
Click "PTMs (SA)-databases-database devices" and we will see that the master database on the right has only 30 mb of space. We will expand it to 500 mb. If there is no previous operation, expansion won't succeed here. Right-click "properties", change "30" to "500", and click "OK ".
The master size has been upgraded to 500 mb.
Right-click the master on the left and select "properties"
Select "devices" and click "add". In the displayed dialog box, select the "transaction log" radio button,
Click "master" to make it selected. Enter 400 in the following size to allocate MB space for data and log. Click OK.
Create a new database named "PTMs". First, create a data file and log file. Click database devices in the left-side view to make it selected.
You can see add database device and master in "details" on the right. Right-click the blank space and click "new". A dialog box is displayed.
In the dialog box that appears, enter "PTMs", that is, the name of the data file, and click "Next"
"Device number" is not required. The default value is. Just fill in the number in "size". I fill in 4000, that is, the data file has 4 GB size, because the unit is M. Next step
Next step
Complete
In the same way, create a log file with a size of 500 mb ). Complete
The data file and log file have been created. Let's create a new database!
Click databases in the left-side directory tree"
In the same way as creating a data file, click "new"-"Database" in the blank area on the right"
In the displayed dialog box, enter "PTMs" (database name)
Click "Next". In the displayed dialog box, click "add ".
Select the "data" radio button, click "PTMs", and enter the maximum value in the "size" below. My maximum value is MB.
Click "OK". The 4G data file you just created will be added to the PTMs data of the database, and the log file will be added to the database. The method is the same as above. (Image text)
In this way, the data files "PTMs" and "ptmslog" become the data and log storage files of the Database "PTMs ".
Click "Next" and select "for load" in the check box, because we will import the new database from the backup file of a database, and click "Next"
Next step
Complete
Creating a database is a process that is a little slow, just wait...
After the creation, you will find a downward yellow arrow on PTMs, which means it is not available yet, because there is no data and no parameters are set, we will import data from a data backup file to this database, and then set some parameters.
Run the command iSQL-USA-P in DOS to log on to the database and enter "load database PTMs from" E:/plms. dat ", this command is the inverted database command, that is, the plms under the e disk. import the data in the DAT file to the current database and run go.
However, when you press the Enter key, you suddenly find the problem: "can't open a connection to site 'syb _ backup. see the error log file in the SQL Server boot directory. ", this is because the backup service is not started. We can start this service from the" control panel-management tools "service.
After the service is started, the system returns to DOS to execute the inverted database command, which is also a long task...
Run the online command after the database is dumped,
Create a user whose username and password are Sybase and have all the roles and permissions. Click "logins" in the left-side directory tree"
Several default users are displayed. Right-click the blank space and choose "New" and "login"
In the dialog box that appears, enter "sybase" in all three input boxes"
Next, select the default database and language. Next
Select All and click Next.
Complete
After the user is created, refresh the page and you will see the newly added Sybase. Right-click and select "properties"
Select users, click Add, select all, and click OK.
After joining
Add a role. The method is similar. Select all roles.
User Created!
Set database parameters, right-click "PTMs" in the left-side directory tree, and select "properties". In the "options" dialog box that appears, select DDL in Tran, no free space acctg, select into/bulkcopy/pllsort, trunc log on chkpt and other four parameters, OK
OK. The entire process of database creation and database backup has basically ended. Use Sybase/Sybase to log on to the PTMs database!
Collection of porn sister Edition Software for many years-men's essentials, today to share the speed:
China Telecom official download point 1
China Telecom official Download Site 2
China Netcom official download site 1
China Netcom official Download Site 2
Start building with 50+ products and up to 12 months usage for Elastic Compute Service
1 on 1 presale consultation
24/7 Technical Support 6 Free Tickets per Quarter Faster Response
Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.
A comprehensive suite of global cloud computing services to power your business
Payment Methods We Support
