Will a server reboot trigger a failover?
In a clustered environment the application will failover to the passive node if the active node is rebooted. Best practice would be to manually failover the application before the reboot. You could allow the application to failback once the original active has come back but I would recommend doing that under manual control
View Answer
| April 7, 2010 6:39 PM
Backup Server, Failover, Failover Clustering, Server Reboot
In a clustered environment the application will failover to the passive node if the active node is rebooted. Best practice would be to manually failover the application before the reboot. You could allow the application to failback once the original active has come back but I would recommend doing that under manual control
View Answer
| April 7, 2010 6:39 PM
Backup Server, Failover, Failover Clustering, Server Reboot
Which task does the backup server do?
It would depend on the service which you are clustering, but typically the failed transaction would be rolled back, and the next command would then be picked up by the database server. Mr Denny, could you explain your statement, “the failed transaction would be rolled back, and the next command would be picked up by [...]
View Answer
| April 7, 2010 6:09 PM
Backup Server, Failover, Failover Clustering, Server administration
It would depend on the service which you are clustering, but typically the failed transaction would be rolled back, and the next command would then be picked up by the database server. Mr Denny, could you explain your statement, “the failed transaction would be rolled back, and the next command would be picked up by [...]
View Answer
| April 7, 2010 6:09 PM
Backup Server, Failover, Failover Clustering, Server administration
remove a trigger file record lock
You should read up on the ALWREPCHG parameter of the ADDPFTRG command.
View Answer
| April 7, 2010 6:07 PM
CLLE, Record lock, RPGLE Program, TRIGGER
You should read up on the ALWREPCHG parameter of the ADDPFTRG command.
View Answer
| April 7, 2010 6:07 PM
CLLE, Record lock, RPGLE Program, TRIGGER
How could automated failover ever be justified?
Typically when you are setting up an Active/Passive cluster, the only software license cost you have is for the Windows OS. So for example if it is a SQL Server, you only need to license one copy of SQL Server. When patching is done correctly both nodes of the cluster shouldn’t ever go down at [...]
View Answer
| April 7, 2010 5:58 PM
Failover, MS failover software
Typically when you are setting up an Active/Passive cluster, the only software license cost you have is for the Windows OS. So for example if it is a SQL Server, you only need to license one copy of SQL Server. When patching is done correctly both nodes of the cluster shouldn’t ever go down at [...]
View Answer
| April 7, 2010 5:58 PM
Failover, MS failover software
In-Memory Processing Storage options
No matter what in memory system you get you have to write the data to disk at some point, otherwise when the server reboots or fails you’ve lost your data. How large is your database, and what problems are you seeing? Personally I’ve got a 1 TB OLTP database serving 45k users daily without any [...]
View Answer
| April 7, 2010 5:37 PM
In-Memory Database, Microsoft Office, Microsoft Vista, Relational database management systems, Relational databases
No matter what in memory system you get you have to write the data to disk at some point, otherwise when the server reboots or fails you’ve lost your data. How large is your database, and what problems are you seeing? Personally I’ve got a 1 TB OLTP database serving 45k users daily without any [...]
View Answer
| April 7, 2010 5:37 PM
In-Memory Database, Microsoft Office, Microsoft Vista, Relational database management systems, Relational databases
.DAT file of unknown structure
This site will give you a good place to start – those .dat files can be very challenging if you don’t know what program is producing them. http://www.online-tech-tips.com/computer-tips/how-to-open-dat-files/ I also searched with a combination of your iPT brand, with .dat, and came up with the following site: http://filesharefreak.com/2008/11/02/utorrent-move-all-your-downloaded-files-keep-seeding/ Hope this helps!
View Answer
| April 7, 2010 5:16 PM
VB, VBA
This site will give you a good place to start – those .dat files can be very challenging if you don’t know what program is producing them. http://www.online-tech-tips.com/computer-tips/how-to-open-dat-files/ I also searched with a combination of your iPT brand, with .dat, and came up with the following site: http://filesharefreak.com/2008/11/02/utorrent-move-all-your-downloaded-files-keep-seeding/ Hope this helps!
View Answer
| April 7, 2010 5:16 PM
VB, VBA
Storage vs Data Warehouse
Storage would be physical hardware, with everything else happening within the software.
View Answer
| April 7, 2010 4:40 PM
Data warehouse, Storage, Storage in 2010
Storage would be physical hardware, with everything else happening within the software.
View Answer
| April 7, 2010 4:40 PM
Data warehouse, Storage, Storage in 2010
file upload to multiple servers using http
You would need to use some sort of replication at the server level to ensure that all the data is replicated between the two servers. What OS are you using?
View Answer
| April 7, 2010 4:39 PM
CMS, File upload, HTTP, Load balancing, PHP
You would need to use some sort of replication at the server level to ensure that all the data is replicated between the two servers. What OS are you using?
View Answer
| April 7, 2010 4:39 PM
CMS, File upload, HTTP, Load balancing, PHP
How do I associate an employee # to a name in Excel 2007?
Looks like you could write an Excel Macro, with the employee numbers and names in a different sheet of the same workbook. For an example writing a macro : http://www.ozgrid.com/forum/showthread.php?t=55176
View Answer
| April 7, 2010 4:24 PM
excel, Excel 2007, Excel 2007 workbooks, Excel formulas, Microsoft Excel 2007
Looks like you could write an Excel Macro, with the employee numbers and names in a different sheet of the same workbook. For an example writing a macro : http://www.ozgrid.com/forum/showthread.php?t=55176
View Answer
| April 7, 2010 4:24 PM
excel, Excel 2007, Excel 2007 workbooks, Excel formulas, Microsoft Excel 2007
how to take source code from mocha soft to as400 server ?
Forgive my ignorance, but I thought Mochasoft was a 5250 emulator? What do you mean by “developed a small project in MochaSoft”?
View Answer
| April 7, 2010 3:56 PM
AS/400
Forgive my ignorance, but I thought Mochasoft was a 5250 emulator? What do you mean by “developed a small project in MochaSoft”?
View Answer
| April 7, 2010 3:56 PM
AS/400
How to call Microsoft Excel from Oracle Reports/Forms 6i
You could use the DDE package. Dynamic Data Exchange (DDE) is a mechanism by which applications can communicate and exchange data in Windows. In this case, you would need to use the function App_Begin. This is the syntax: The following code can help you specifically about how to implement th DDE package. here is an [...]
View Answer
| April 7, 2010 3:20 PM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, Oracle 6i, Oracle 6i import/export, Oracle developers, Oracle Forms, Oracle Forms 6i, Oracle import/export, Oracle Reports
You could use the DDE package. Dynamic Data Exchange (DDE) is a mechanism by which applications can communicate and exchange data in Windows. In this case, you would need to use the function App_Begin. This is the syntax: The following code can help you specifically about how to implement th DDE package. here is an [...]
View Answer
| April 7, 2010 3:20 PM
Excel import/export, Microsoft Excel, Microsoft Excel import/export, Oracle 6i, Oracle 6i import/export, Oracle developers, Oracle Forms, Oracle Forms 6i, Oracle import/export, Oracle Reports
I am trying to install oracle 9i(3 CDs) on my desktop
It is not a good idea to simply ignore errors. Those installation errors could be causing this problem. However, you can <a href=”http://download.oracle.com/docs/html/A95493_02/install.htm#i1008302″>Review the Installation Session Log</a> and try to find more information about those errors. Also, make sure your computer meets the <a href=”http://download.oracle.com/docs/html/A95493_02/reqs.htm#i1101759″>System Requirements</a>. You could also <a href=”http://download.oracle.com/docs/html/A95493_02/install.htm#i1008321″>Deinstall Oracle Components and Services</a> [...]
View Answer
| April 7, 2010 2:58 PM
Oracle 9i, Oracle 9i installation, Oracle 9i installation errors
It is not a good idea to simply ignore errors. Those installation errors could be causing this problem. However, you can <a href=”http://download.oracle.com/docs/html/A95493_02/install.htm#i1008302″>Review the Installation Session Log</a> and try to find more information about those errors. Also, make sure your computer meets the <a href=”http://download.oracle.com/docs/html/A95493_02/reqs.htm#i1101759″>System Requirements</a>. You could also <a href=”http://download.oracle.com/docs/html/A95493_02/install.htm#i1008321″>Deinstall Oracle Components and Services</a> [...]
View Answer
| April 7, 2010 2:58 PM
Oracle 9i, Oracle 9i installation, Oracle 9i installation errors
Importing History into Microsoft CRM 4.0
You can use the bulk import wizard or data migration manager tool and note that status code should be set as ‘Completed’
View Answer
| April 7, 2010 2:25 PM
Microsoft CRM, Microsoft CRM 4.0, Microsoft CRM History Import, Microsoft Dynamics
You can use the bulk import wizard or data migration manager tool and note that status code should be set as ‘Completed’
View Answer
| April 7, 2010 2:25 PM
Microsoft CRM, Microsoft CRM 4.0, Microsoft CRM History Import, Microsoft Dynamics
Command to list files on local system
To create a list of local IFS-files into a physical file, follow these steps: 1. Create the file to recieve the filenames: <pre>CRTPF mylib/mydirlist RCDLEN(12) LVLCHK(*NO)</pre> 2. Make the IFS-directory your current directory: <pre>CD ‘/somedir/myfiledir’</pre> 3. Now use Qshell’s ls command to list the filenames into the physical filefrom step 1. <pre>qsh ‘ls *.* > [...]
View Answer
| April 7, 2010 1:56 PM
AS/400
To create a list of local IFS-files into a physical file, follow these steps: 1. Create the file to recieve the filenames: <pre>CRTPF mylib/mydirlist RCDLEN(12) LVLCHK(*NO)</pre> 2. Make the IFS-directory your current directory: <pre>CD ‘/somedir/myfiledir’</pre> 3. Now use Qshell’s ls command to list the filenames into the physical filefrom step 1. <pre>qsh ‘ls *.* > [...]
View Answer
| April 7, 2010 1:56 PM
AS/400
External mail blocking on Exchange 2003
You should follow <a href=”http://www.msexchange.org/tutorials/MF009.html”>these instructions</a>.
View Answer
| April 7, 2010 6:56 AM
Block Users from Sending Email, Exchange 2003, Exchange 2003 administration, Exchange 2003 Enterprise Edition
You should follow <a href=”http://www.msexchange.org/tutorials/MF009.html”>these instructions</a>.
View Answer
| April 7, 2010 6:56 AM
Block Users from Sending Email, Exchange 2003, Exchange 2003 administration, Exchange 2003 Enterprise Edition
What’s more important when choosing a hard drive?
Go for RPM. Cache doesn’t help as much as you would expect. Before you decide, see if <a href=”http://www.pricewatch.com”>pricewatch</a> helps you with good deals.
View Answer
| April 7, 2010 6:50 AM
Adding Hard Drive, Cache Memory, Seagate, western digital
Go for RPM. Cache doesn’t help as much as you would expect. Before you decide, see if <a href=”http://www.pricewatch.com”>pricewatch</a> helps you with good deals.
View Answer
| April 7, 2010 6:50 AM
Adding Hard Drive, Cache Memory, Seagate, western digital
client access in windows 7
this <a href=”http://itknowledgeexchange.techtarget.com/itanswers/pcs-compatanbility/”>previous question</a> may help. ————————- The previous question is a good answer if you are running an older OS. Client Access for V5R4 with the latest service pack or higher is compatible with Windows 7.
View Answer
| April 7, 2010 6:32 AM
Systems administration, Windows 7
this <a href=”http://itknowledgeexchange.techtarget.com/itanswers/pcs-compatanbility/”>previous question</a> may help. ————————- The previous question is a good answer if you are running an older OS. Client Access for V5R4 with the latest service pack or higher is compatible with Windows 7.
View Answer
| April 7, 2010 6:32 AM
Systems administration, Windows 7
What is the maximum size of nodes?
The maximum cluster size depends on the application and operating system. More nodes usually always provides better performance and availability. But there are a few limitations out there; VMware, for instance, has a maximum ESX HA cluster of 32 nodes. Mostly I’ve only heard of recommended maximums, that are either 8, 16, or 32.
View Answer
| April 7, 2010 6:26 AM
Failover, Failover Clustering, Failover Clustering nodes
The maximum cluster size depends on the application and operating system. More nodes usually always provides better performance and availability. But there are a few limitations out there; VMware, for instance, has a maximum ESX HA cluster of 32 nodes. Mostly I’ve only heard of recommended maximums, that are either 8, 16, or 32.
View Answer
| April 7, 2010 6:26 AM
Failover, Failover Clustering, Failover Clustering nodes
What formula is needed for this below in Excel?
If I understand your question correctly, you could use a combination of the <a href=”http://office.microsoft.com/en-us/excel/HP100625621033.aspx”>CONCATENATE</a>, <a href=”http://office.microsoft.com/en-us/excel/HP100698361033.aspx”>FIND</a> and <a href=”http://office.microsoft.com/en-us/excel/HP100625681033.aspx”>LEFT</a> functions. For example, if you have “12400″ (you said back slash) in A1, you could put something like this in A2: <pre>=CONCATENATE(LEFT(A1,FIND(“”,A1)-1)+1,”2400″)</pre> If that’s not what you mean, please provide more details. -CarlosDL ——————
View Answer
| April 7, 2010 1:38 AM
Excel 2003, Excel 2007, Microsoft Excel
If I understand your question correctly, you could use a combination of the <a href=”http://office.microsoft.com/en-us/excel/HP100625621033.aspx”>CONCATENATE</a>, <a href=”http://office.microsoft.com/en-us/excel/HP100698361033.aspx”>FIND</a> and <a href=”http://office.microsoft.com/en-us/excel/HP100625681033.aspx”>LEFT</a> functions. For example, if you have “12400″ (you said back slash) in A1, you could put something like this in A2: <pre>=CONCATENATE(LEFT(A1,FIND(“”,A1)-1)+1,”2400″)</pre> If that’s not what you mean, please provide more details. -CarlosDL ——————
View Answer
| April 7, 2010 1:38 AM
Excel 2003, Excel 2007, Microsoft Excel
I am trying to use RUNRMTCMD from my i5 to a Windows 2003 server running VMWare.
I’m not a 400 (err.. i5) guy myself but I’ve had some experiences with them. I <b>can </b>speak from a windows perspective and say from my searches on the internet it would be possible. <a href=”http://archive.midrange.com/midrange-l/200506/msg01515.html”>Here </a>is a link to a discussion that looks promising. From teh windows side you are going to want to [...]
View Answer
| April 7, 2010 12:09 AM
i5, RUNRMTCMD, VMware, Windows Server 2003
I’m not a 400 (err.. i5) guy myself but I’ve had some experiences with them. I <b>can </b>speak from a windows perspective and say from my searches on the internet it would be possible. <a href=”http://archive.midrange.com/midrange-l/200506/msg01515.html”>Here </a>is a link to a discussion that looks promising. From teh windows side you are going to want to [...]
View Answer
| April 7, 2010 12:09 AM
i5, RUNRMTCMD, VMware, Windows Server 2003
