How to use Insert command between two servers to speed up performance
Your best bet will probably be to use SSIS to copy the records to the other server. This will allow you to control how large the batches are as they are inserted.
View Answer
| April 18, 2010 3:22 AM
sql 2005 Performance Issues, SQL database replication, SQL Express, SQL Server 2005, SQL Server 2005 performance
Your best bet will probably be to use SSIS to copy the records to the other server. This will allow you to control how large the batches are as they are inserted.
View Answer
| April 18, 2010 3:22 AM
sql 2005 Performance Issues, SQL database replication, SQL Express, SQL Server 2005, SQL Server 2005 performance
Need a sample code for Sql fetching multiple rows
I’ve noticed this has been unanswered for a while. I have some expertise in RPG, not COBOL (sorry), but maybe this will help since RPG and COBOL on the iSeries are similar. I’m assuming the embedded SQL is the same. In the sample code below I move SQL results into RPG (program) variables. Those program [...]
View Answer
| April 17, 2010 12:35 AM
SQL, SQLCBLLE
I’ve noticed this has been unanswered for a while. I have some expertise in RPG, not COBOL (sorry), but maybe this will help since RPG and COBOL on the iSeries are similar. I’m assuming the embedded SQL is the same. In the sample code below I move SQL results into RPG (program) variables. Those program [...]
View Answer
| April 17, 2010 12:35 AM
SQL, SQLCBLLE
Associate or link cells in Excel
I think you need SumIF. Example: =SUMIF(B$21:B$50,A1,C$21:C$50) In that example I’m imagining that your 31 x 13 range starts in cell A20 (Row 20 contains column headings). In column A is the sales associate’s name or ID. In column B is the Team they belong to. In column C is the sales amount. Now at [...]
View Answer
| April 17, 2010 12:10 AM
Microsoft Excel
I think you need SumIF. Example: =SUMIF(B$21:B$50,A1,C$21:C$50) In that example I’m imagining that your 31 x 13 range starts in cell A20 (Row 20 contains column headings). In column A is the sales associate’s name or ID. In column B is the Team they belong to. In column C is the sales amount. Now at [...]
View Answer
| April 17, 2010 12:10 AM
Microsoft Excel
Failover Cluster Management
Failover Cluster Management is the name of the management tool which is used to manage a Microsoft Cluster Server cluster.
View Answer
| April 16, 2010 11:39 PM
Failover, Failover Cluster Management, Failover Clustering
Failover Cluster Management is the name of the management tool which is used to manage a Microsoft Cluster Server cluster.
View Answer
| April 16, 2010 11:39 PM
Failover, Failover Cluster Management, Failover Clustering
Active to active failover assumption
I assume that you are talking about VMs here? If the host is full, then the guest simply won’t be brought online.
View Answer
| April 16, 2010 11:36 PM
Failover, Failover Clustering, Failover Clustering nodes
I assume that you are talking about VMs here? If the host is full, then the guest simply won’t be brought online.
View Answer
| April 16, 2010 11:36 PM
Failover, Failover Clustering, Failover Clustering nodes
Is there any danger?
Usually no, as the nodes are independent of each other. However if you have an 8 node cluster, and you have the clustered configured in a way that allows for only 2 nodes to fail, and a third node fails then all the clustered resources will fail.
View Answer
| April 16, 2010 11:33 PM
Failover, Failover Clustering, Failover Clustering nodes
Usually no, as the nodes are independent of each other. However if you have an 8 node cluster, and you have the clustered configured in a way that allows for only 2 nodes to fail, and a third node fails then all the clustered resources will fail.
View Answer
| April 16, 2010 11:33 PM
Failover, Failover Clustering, Failover Clustering nodes
debugging a program object on i-series
As long as it was compiled with some some level of debug information, yes. Ideally (without source), DBGVIEW(*LIST) would be far better than DBGVIEW(*STATEMENT). For ILE, use DSPPGM and either page forward to the *MODULE detail or specify DETAIL(*MODULE) to see if debug data was left in the *PGM object. For OPM, it’s not so [...]
View Answer
| April 16, 2010 11:13 PM
AS/400 debugging, iSeries, RPG, RPGLE
As long as it was compiled with some some level of debug information, yes. Ideally (without source), DBGVIEW(*LIST) would be far better than DBGVIEW(*STATEMENT). For ILE, use DSPPGM and either page forward to the *MODULE detail or specify DETAIL(*MODULE) to see if debug data was left in the *PGM object. For OPM, it’s not so [...]
View Answer
| April 16, 2010 11:13 PM
AS/400 debugging, iSeries, RPG, RPGLE
ADD trigger gives a Cross Reference Failed error
IBM has a PTF for this. You can check it out at: http://www-01.ibm.com/support/docview.wss?uid=nas3aaebb37753aefbef86256e990073e4b8 I have also seen several threads via google that state the problem can be fixed using the RCLSTG command; see links below. http://www.itjungle.com/mgo/mgo022103-readers.html http://archive.midrange.com/midrange-l/200404/msg00065.html http://forums.systeminetwork.com/isnetforums/archive/index.php/t-48612.html ============================================================== <b>Be careful</b> using RCLSTG to fix this issue. It’s is very likely that the form of [...]
View Answer
| April 16, 2010 9:46 PM
i5/OS, IBM WebSphere, Trigger failure
IBM has a PTF for this. You can check it out at: http://www-01.ibm.com/support/docview.wss?uid=nas3aaebb37753aefbef86256e990073e4b8 I have also seen several threads via google that state the problem can be fixed using the RCLSTG command; see links below. http://www.itjungle.com/mgo/mgo022103-readers.html http://archive.midrange.com/midrange-l/200404/msg00065.html http://forums.systeminetwork.com/isnetforums/archive/index.php/t-48612.html ============================================================== <b>Be careful</b> using RCLSTG to fix this issue. It’s is very likely that the form of [...]
View Answer
| April 16, 2010 9:46 PM
i5/OS, IBM WebSphere, Trigger failure
Add Special Authority to User Profiles
In order to add authority to a profile, your profile must already have that authority. According to the IBM help screen: *SECADM Security administrator authority is given to the user. The user can create, change, or delete user profiles if authorized to the Create User Profile (CRTUSRPRF), Change User Profile (CHGUSRPRF), or Delete User Profile [...]
View Answer
| April 16, 2010 9:42 PM
AS/400, i5/OS, iServer
In order to add authority to a profile, your profile must already have that authority. According to the IBM help screen: *SECADM Security administrator authority is given to the user. The user can create, change, or delete user profiles if authorized to the Create User Profile (CRTUSRPRF), Change User Profile (CHGUSRPRF), or Delete User Profile [...]
View Answer
| April 16, 2010 9:42 PM
AS/400, i5/OS, iServer
F4 prompt not displaying in window using RPGLE
Is the F4 defined in the pop-up DDS? Or is it used to trigger the pop-up window? Check to see how the function key is defined CF04 and CA04 will work differently.
View Answer
| April 16, 2010 7:39 PM
AS/400, Prompt F4, RPGLE, RPGLE Program
Is the F4 defined in the pop-up DDS? Or is it used to trigger the pop-up window? Check to see how the function key is defined CF04 and CA04 will work differently.
View Answer
| April 16, 2010 7:39 PM
AS/400, Prompt F4, RPGLE, RPGLE Program
Exchange 2007 cannot send mail to many domains
When you test using telnet, do you go from the Exchange server or a client machine? Do you get the same results from a client machine? Has something changed on your perimeter firewall connection? Try using <a href=”http://www.wireshark.org”>Wireshark</a> or Microsoft’s Network Monitor to capture traffic to/from the Exchange server and see which end of the [...]
View Answer
| April 16, 2010 5:55 PM
Exchange 2007, Exchange Server 2007, IP address, SMTP transmission failure, Windows Server 2003, Windows Server 2003 administration
When you test using telnet, do you go from the Exchange server or a client machine? Do you get the same results from a client machine? Has something changed on your perimeter firewall connection? Try using <a href=”http://www.wireshark.org”>Wireshark</a> or Microsoft’s Network Monitor to capture traffic to/from the Exchange server and see which end of the [...]
View Answer
| April 16, 2010 5:55 PM
Exchange 2007, Exchange Server 2007, IP address, SMTP transmission failure, Windows Server 2003, Windows Server 2003 administration
Nagios Integration with Speedfan
While I’ve not yet addressed the check_sfan.pl script and its functionality yet, I have successfully configured Speedfan to run as a service. It took some work with the resource toolkit from Microsoft, and some registry editing, but the service starts automatically. I used the option to allow the service to interact with the desktop to [...]
View Answer
| April 16, 2010 5:28 PM
IT Infrastructure Monitoring, Nagios, Speedfan
While I’ve not yet addressed the check_sfan.pl script and its functionality yet, I have successfully configured Speedfan to run as a service. It took some work with the resource toolkit from Microsoft, and some registry editing, but the service starts automatically. I used the option to allow the service to interact with the desktop to [...]
View Answer
| April 16, 2010 5:28 PM
IT Infrastructure Monitoring, Nagios, Speedfan
A random thought about failovers and reboots
<b><i>”…a failover is a reboot without the time factor, so even more problems get kicked down the road.”</i></b> Since downtime usually means money, it makes a lot of sense to replace reboots with failover and reduce downtime to 0. The cost would be too high if every incident needed to be investigated in real time [...]
View Answer
| April 16, 2010 5:24 PM
Failover, reboots
<b><i>”…a failover is a reboot without the time factor, so even more problems get kicked down the road.”</i></b> Since downtime usually means money, it makes a lot of sense to replace reboots with failover and reduce downtime to 0. The cost would be too high if every incident needed to be investigated in real time [...]
View Answer
| April 16, 2010 5:24 PM
Failover, reboots
Manage another Exchange user’s delete settings
Certainly, an Exchange Admin with full administrative rights can create a profile on their PC with the user’s id without having to log in as them. If they open the user’s mailbox as its own profile they can change those settings. I have had to do this many times for people who need their out [...]
View Answer
| April 16, 2010 5:07 PM
Exchange 2003, Exchange 2003 administration, Outlook Web Access
Certainly, an Exchange Admin with full administrative rights can create a profile on their PC with the user’s id without having to log in as them. If they open the user’s mailbox as its own profile they can change those settings. I have had to do this many times for people who need their out [...]
View Answer
| April 16, 2010 5:07 PM
Exchange 2003, Exchange 2003 administration, Outlook Web Access
Microsoft / Dell / ASAP Negotiations
ASAP is like all other software suppliers. There will be a certain margin that they take but it is useful to be able to work with your Dell team to manage the hardware & software under one account team. It can enable you to better leverage purchasing hardware and software bundles together rather than from [...]
View Answer
| April 16, 2010 4:27 PM
Dell, Microsoft, Negotiations, Product Selection
ASAP is like all other software suppliers. There will be a certain margin that they take but it is useful to be able to work with your Dell team to manage the hardware & software under one account team. It can enable you to better leverage purchasing hardware and software bundles together rather than from [...]
View Answer
| April 16, 2010 4:27 PM
Dell, Microsoft, Negotiations, Product Selection
UPS redundancy vendor support
<b>UPS and Power Distribution design to achieve Redundancy</b> The article you referenced was excellent and easy to read and took the issue head on with many concepts. Let me take an approach that starts with equipment, a server with 2 power supplies and work my back towards the UPS. Unlike that article, I will not [...]
View Answer
| April 16, 2010 2:52 PM
Data center backup power, Data Center power management, UPS redundancy
<b>UPS and Power Distribution design to achieve Redundancy</b> The article you referenced was excellent and easy to read and took the issue head on with many concepts. Let me take an approach that starts with equipment, a server with 2 power supplies and work my back towards the UPS. Unlike that article, I will not [...]
View Answer
| April 16, 2010 2:52 PM
Data center backup power, Data Center power management, UPS redundancy
What are your favorite networking blogs?
<a href=”http://compnetworking.about.com/”> Bradley Mitchell’s blog at About.com</a> <a href=”http://itknowledgeexchange.techtarget.com/networkhub/”>Network Hub blog</a> Security Levity by Amir Lev And read more on the <a href=”http://itknowledgeexchange.techtarget.com/IT-watch-blog/your-guide-to-the-networking-blogosphere/”>IT Watch blog</a>, or add suggestions here.
View Answer
| April 16, 2010 2:30 PM
Blogs, LAN, Networking, Networking in 2010, WAN
<a href=”http://compnetworking.about.com/”> Bradley Mitchell’s blog at About.com</a> <a href=”http://itknowledgeexchange.techtarget.com/networkhub/”>Network Hub blog</a> Security Levity by Amir Lev And read more on the <a href=”http://itknowledgeexchange.techtarget.com/IT-watch-blog/your-guide-to-the-networking-blogosphere/”>IT Watch blog</a>, or add suggestions here.
View Answer
| April 16, 2010 2:30 PM
Blogs, LAN, Networking, Networking in 2010, WAN
OpenSource Software
I’m assuming you want a free “Active Directory” basically for authentication. You can use TekRADIUS, freeware http://www.tekradius.com/. As per changing the bandwidth, are you referring to bandwidth to the application package? If that is the case, you would need to refer how the application works via a regular browser or a fat client on the [...]
View Answer
| April 16, 2010 2:29 PM
Internet service providers, OpenSoruce Software, Password policies
I’m assuming you want a free “Active Directory” basically for authentication. You can use TekRADIUS, freeware http://www.tekradius.com/. As per changing the bandwidth, are you referring to bandwidth to the application package? If that is the case, you would need to refer how the application works via a regular browser or a fat client on the [...]
View Answer
| April 16, 2010 2:29 PM
Internet service providers, OpenSoruce Software, Password policies
Odd Windows password reset issues
At the workstation’s command prompt, type: gpresult >group.txt You can see what policy is hitting a particular computer. This may help you trace the problem. You can setup site and services so the subnet that the user workstation are located would attempt to authenticate first to that particular server (Windows 2003).
View Answer
| April 16, 2010 2:00 PM
Password policies, password reset, Windows Server 2003, Windows Server 2003 administration, Windows Server 2008, Windows Server 2008 Administration, Windows XP, Windows XP administration
At the workstation’s command prompt, type: gpresult >group.txt You can see what policy is hitting a particular computer. This may help you trace the problem. You can setup site and services so the subnet that the user workstation are located would attempt to authenticate first to that particular server (Windows 2003).
View Answer
| April 16, 2010 2:00 PM
Password policies, password reset, Windows Server 2003, Windows Server 2003 administration, Windows Server 2008, Windows Server 2008 Administration, Windows XP, Windows XP administration
Cost per server of the failover software?
Cost would vary greatly depending on the failover application’s feature and licensing scheme. You would normally see a price reduction if your servers are virtual. One product that works great is XOSoft High Availability and works in a active passive mode.
View Answer
| April 16, 2010 1:48 PM
Failover, Failover Clustering
Cost would vary greatly depending on the failover application’s feature and licensing scheme. You would normally see a price reduction if your servers are virtual. One product that works great is XOSoft High Availability and works in a active passive mode.
View Answer
| April 16, 2010 1:48 PM
Failover, Failover Clustering
