Networking

Unix and Linux network configuration. Multiple network interfaces. Bridged NICs. High-availability network configurations.

Applications

Reviews of latest Unix and Linux software. Helpful tips for application support admins. Automating application support.

Data

Disk partitioning, filesystems, directories, and files. Volume management, logical volumes, HA filesystems. Backups and disaster recovery.

Monitoring

Distributed server monitoring. Server performance and capacity planning. Monitoring applications, network status and user activity.

Commands & Shells

Cool Unix shell commands and options. Command-line tools and application. Things every Unix sysadmin needs to know.

Home » Applications, Disks and Volumes

Informix database migration on HP-UX

Submitted by on May 1, 2006 – 10:51 am 4 Comments

Rather than rebuilding an Informix database on the new HP-UX server, it possible to migrate the existing installation from the old server. The database resides on raw disks with transparent volumes that are not visible in /etc/fstab, or via bdf or df -k.

To view the database volumes on the old server:

cd /dev/vx/rdsk/dgxxx/dbvolxxx

Once there, you can view the size of the volumes, which will need to be re-created on the new server:

vxprint -rth  (volume_name)

On the new server create a disk group using VxVM or LVM. Then create database volumes using parameters shown by vxprint from the previous step. Do not create any file systems.

On the old server go to /dev/vx/rdsk/dgxxx/(volume_name) and note permissions and ownership for each directory level. Replicate these settings on the new server.

Use the dd command to copy each volume from the old server to the new server. You will need to add hostname and IP of the old server to the ~/.rhosts file on the new server to allow remsh operations under root account.

/usr/bin/dd if=/dev/vx/rdsk/dgxxx/(volume_name) bs=64k | remsh (newserver) -l root /usr/bin/dd of=/dev/vx/rdsk/dgxxx/(volume_name) bs=64k

Have the DBAs verify database integrity.

Print Friendly, PDF & Email

4 Comments »

  • tefa_96 says:

    Operating System Design/Case studies

    The goal of this study is to discuss the different issues involved in operating system design, the different strategies that have been tried and to provide concrete examples where possible. Given the number of open-source operating systems available, specific implementations will be used as examples where possible.

    Contents
    1 Example Operating Systems
    2 Example filesystems
    3 Case Study Areas
    4 Further reading

    Example Operating Systems

    Naturally, open source operating systems lend themselves to teaching more than proprietary operating systems. The source code of all the following operating systems is available free of charge online:
    Linux
    Net/Free/OpenBSD
    Solaris
    MINIX
    GNU Hurd
    XOK
    ReactOS

    While the following operating systems are closed source, enough is known about their implementation that they can all be used as specific examples of approaches to various OS design issues and tasks.
    Mac OS X
    Microsoft Windows 9x
    Windows NT
    QNX
    DOS
    HP-UX
    AIX
    BeOS

    Example filesystems
    FAT
    NTFS
    ext4

    Case Study Areas

    The following areas of operating system design can all be illustrated with specific examples from real operating systems. In some cases different approaches to the same task can be seen within one OS. For example, many operating systems support multiple file system types.
    Loading the operating system
    Initialising the operating system for use
    Managing tasks (processes)
    Managing memory
    File systems and storage management
    User interfaces

    For example, in the “Managing tasks” section we might use the example of task management in a single tasking operating system like DOS, as well as some of the different scheduling algorithms that have been used in various multitasking operating systems.

    The case study can include comparative analysis about any concept of different operating systems or comparison between the different versions of same operating systems. It can include the total functionality of the operating system given.

  • Kristian says:

    hi, i have been looking for the type of database association but i cannot find it in the internet. Help….
    What are the types of database association?

  • uberfailz says:

    Hello,

    I have a need to create a procedure and use a select at the same time(don’t ask why).

    I’m use RazorSQL to interface with my Informix DB.

    SELECT name FROM users WHERE id = 3 AND 1 = (CREATE PROCEDURE createtxt2() SYSTEM ‘echo damn > superman.php’; END PROCEDURE;);

    This gives me a Syntax Error. However:
    SELECT name FROM users WHERE id = 3; superman.php’; END PROCEDURE; <– works fine

    Is there a way to put them both together in 1 sql query?

    Thanks in advance.

  • EzioAuditore1459 says:

    Question one says… :
    Discuss the features,application, and limitations of any five free RDBMS software

    Question two also says.. :
    Discuss features and application of the following database management systems.. :
    a.PostgreSQL
    e.Informix

    Question Three.. :
    Discuss and compare the following database management system in terms of security, reliablility, and GUI tools:
    a.Oracle
    b.sybase
    c.DB2

Leave a Reply

%d bloggers like this: