Blog
i can

Dawn May

Dawn May




Bookmark and Share

October 2014

Sun Mon Tue Wed Thu Fri Sat
      1 2 3 4
5 6 7 8 9 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30 31  

« COMMON Annual Meeting, Spring 2013 | Main | Integrate Web Services With DB2 for i 7.1 Part Two »

April 17, 2013

Comments

LS is about mirror.

Because of SLS, is it impossible to create a distributed database in IBMi?

I´d like to see a feature in IBMi where i can switch iASP in seconds and i dont need to varyonn the database in the second node.

The following information was provided by my DB2 contacts:

Single-level store does not prevent from doing what you want.
In general, an IASP is also a relational database. The IASP must be varied on or the disks simply are not available. However, you do not have to switch to the IASP to access the database. Like any other database product, your application can issue an SQL CONNECT statement to connect to that database and issue SQL statements.

Even easier, we support 3-part names and aliases in SQL so we can implicitly connect for you when you issue an SQL statement that references a remote database.

The comments to this entry are closed.