Isolate the hot rows or the cold rows in a data center?
The simple answer is isolate the cold isle providing you have sufficient cold air flow. If you contain the hot isle you need to cool the surrounding building areas, this creates non focused cooling and additional heat loss to areas not required. Eg with cold isles containment you only cool the cold isle not the [...]
View Answer
| March 1, 2010 4:34 AM
Cold aisle, Data center cooling, Data center design, Data Center Layout, FM-200, FM-200 Fire Suppression Systems, Hot aisle, Hot Aisle/Cold Aisle
The simple answer is isolate the cold isle providing you have sufficient cold air flow. If you contain the hot isle you need to cool the surrounding building areas, this creates non focused cooling and additional heat loss to areas not required. Eg with cold isles containment you only cool the cold isle not the [...]
View Answer
| March 1, 2010 4:34 AM
Cold aisle, Data center cooling, Data center design, Data Center Layout, FM-200, FM-200 Fire Suppression Systems, Hot aisle, Hot Aisle/Cold Aisle
What questions should we ask a project manager who will oversee a data center move?
Things I would want to know (as a starter) 1) have they done this before? 2) If so when, where and how big a project? 3) if so what issuesproblems did they see and how did they overcome them? 4) If no what do they expect the problems to be? 5) How do they will [...]
View Answer
| February 27, 2010 3:23 PM
Data Center Logistics, Data Center Migration, Data center moving, Project management
Things I would want to know (as a starter) 1) have they done this before? 2) If so when, where and how big a project? 3) if so what issuesproblems did they see and how did they overcome them? 4) If no what do they expect the problems to be? 5) How do they will [...]
View Answer
| February 27, 2010 3:23 PM
Data Center Logistics, Data Center Migration, Data center moving, Project management
Send a notification when a system halt occurs afterhours
I had a similar problem with my servers, that did not have alot of space left. they would fill up and stop printing or responding. I started using blat262 and setup the parameters to send an email out to myself when the performance counter was triggered. You could adapt this kind of code to your [...]
View Answer
| February 26, 2010 8:33 PM
halt, notification, REMOTE, System monitoring
I had a similar problem with my servers, that did not have alot of space left. they would fill up and stop printing or responding. I started using blat262 and setup the parameters to send an email out to myself when the performance counter was triggered. You could adapt this kind of code to your [...]
View Answer
| February 26, 2010 8:33 PM
halt, notification, REMOTE, System monitoring
Formulae used in a data centre power calculation
Your storage provider should be able to provide you with the numbers that you need.
View Answer
| February 26, 2010 7:35 PM
Data Center power management
Your storage provider should be able to provide you with the numbers that you need.
View Answer
| February 26, 2010 7:35 PM
Data Center power management
Keeping a UPS cool – EATON/Powerware 9390
Outside of convincing you that the building attic is a poor choice, the only solution I have is a cooling rack. The Powerware 9390 – 120kVA should remain between 68 and 77 degrees with a limit of 104 before issues arise (according to the manual). The racking you choose should take into consideration the rate [...]
View Answer
| February 25, 2010 8:22 PM
Data center cooling, Powerware, UPS
Outside of convincing you that the building attic is a poor choice, the only solution I have is a cooling rack. The Powerware 9390 – 120kVA should remain between 68 and 77 degrees with a limit of 104 before issues arise (according to the manual). The racking you choose should take into consideration the rate [...]
View Answer
| February 25, 2010 8:22 PM
Data center cooling, Powerware, UPS
How expensive are GETMAINs to a transaction in CICS?
I’ve never used a GETMAIN in a CICS application program. I have only used them in batch jobs. I cannot give you a diffinative answer as to the cost of a GETMAIN and its associated FREEMAIN. But <i>anything</i> that is done in a CICS program 10 <i>thousand</i> times has to be expensive. Reducing the number [...]
View Answer
| February 25, 2010 4:42 PM
CICS, Data Center management, Data Center Storage
I’ve never used a GETMAIN in a CICS application program. I have only used them in batch jobs. I cannot give you a diffinative answer as to the cost of a GETMAIN and its associated FREEMAIN. But <i>anything</i> that is done in a CICS program 10 <i>thousand</i> times has to be expensive. Reducing the number [...]
View Answer
| February 25, 2010 4:42 PM
CICS, Data Center management, Data Center Storage
What is the recommended Temperature and Humidity range for data center?
Within our data center, we have the temperature range approximately 67 to 69 degrees with humidity between 45 to 49. <a href=”http://www.openxtra.co.uk/articles/data-center-environmental”>OpenXtra</a> Recommends the following environment: Acceptable Temperature: 70 to 74 degrees F 21 to 23 degrees C Acceptable Relative Humidity Levels: 45% to 60%
View Answer
| February 25, 2010 11:15 AM
Data center cooling, Data Center Humidity
Within our data center, we have the temperature range approximately 67 to 69 degrees with humidity between 45 to 49. <a href=”http://www.openxtra.co.uk/articles/data-center-environmental”>OpenXtra</a> Recommends the following environment: Acceptable Temperature: 70 to 74 degrees F 21 to 23 degrees C Acceptable Relative Humidity Levels: 45% to 60%
View Answer
| February 25, 2010 11:15 AM
Data center cooling, Data Center Humidity
Install cat. 7 cables in flush floor metal trunking or inside PVC conduits?
I would suggest going with metal. You can run into problems when pulling large amounts of cabling through PVC due to heat. If you choose steel, it will also assist in reducing and EMI. Steel is more maleable than PVC which reduces the number of elbows you may need to introduce. You could also use [...]
View Answer
| February 24, 2010 10:56 PM
Data center cabling
I would suggest going with metal. You can run into problems when pulling large amounts of cabling through PVC due to heat. If you choose steel, it will also assist in reducing and EMI. Steel is more maleable than PVC which reduces the number of elbows you may need to introduce. You could also use [...]
View Answer
| February 24, 2010 10:56 PM
Data center cabling
Looping through a Database
If you are using SQL 2005 or newer you can next sp_MSforeachtable within sp_MSforeachdb. If you are using SQL 2000 or older you’ll need to use a cursor outside the sp_MSforeachtable. Something like this should do the trick. <pre>declare @db sysname, @sql varchar(4000) declare cur CURSOR FOR SELECT name from sysdatabases where name <> ‘tempdb’ [...]
View Answer
| February 24, 2010 10:34 PM
Looping, Servers, SQL Server
If you are using SQL 2005 or newer you can next sp_MSforeachtable within sp_MSforeachdb. If you are using SQL 2000 or older you’ll need to use a cursor outside the sp_MSforeachtable. Something like this should do the trick. <pre>declare @db sysname, @sql varchar(4000) declare cur CURSOR FOR SELECT name from sysdatabases where name <> ‘tempdb’ [...]
View Answer
| February 24, 2010 10:34 PM
Looping, Servers, SQL Server
CICS program with TSQ — transaction troubleshooting
AICA is the abend code for CICS/TS runaway program – program running for longer than the runaway time setting which is a PARM on the system initialization table (SIT). This means that the program ran for too long WITHOUT GIVING UP CONTROL. (too long being defined by the parm in the SIT. I am not [...]
View Answer
| February 24, 2010 8:18 PM
CICS
AICA is the abend code for CICS/TS runaway program – program running for longer than the runaway time setting which is a PARM on the system initialization table (SIT). This means that the program ran for too long WITHOUT GIVING UP CONTROL. (too long being defined by the parm in the SIT. I am not [...]
View Answer
| February 24, 2010 8:18 PM
CICS
Data center security concerns — public access trails around a data storage center
There should be no concern with the public trail as long as the facility maintains physical security protocls for the building and adjacent generators, etc. If that’s the case, the generators and such should be place behind a secure area. I’ve seen data centers surrounded by retail buildings and there have been no security concern. [...]
View Answer
| February 24, 2010 7:34 PM
Data center design, Data Center Security
There should be no concern with the public trail as long as the facility maintains physical security protocls for the building and adjacent generators, etc. If that’s the case, the generators and such should be place behind a secure area. I’ve seen data centers surrounded by retail buildings and there have been no security concern. [...]
View Answer
| February 24, 2010 7:34 PM
Data center design, Data Center Security
Should the data center have a full glass wall on the front side? TIA 942 standards, heating and cooling
Any particular reason why you want/need a glass wall outside of visibiliy pleasing to the eye? I’ve seen various data centers with a front glass wall where the main entrance door to the DC and they had no issues with the heating and cooling of the rooms. You should review the various glass vendors to [...]
View Answer
| February 24, 2010 7:29 PM
Data center cooling, Data center design, Data Center Layout, Hot Aisle/Cold Aisle, TIA 942, TIA 942 Standard
Any particular reason why you want/need a glass wall outside of visibiliy pleasing to the eye? I’ve seen various data centers with a front glass wall where the main entrance door to the DC and they had no issues with the heating and cooling of the rooms. You should review the various glass vendors to [...]
View Answer
| February 24, 2010 7:29 PM
Data center cooling, Data center design, Data Center Layout, Hot Aisle/Cold Aisle, TIA 942, TIA 942 Standard
Dynamic file allocation in a COBOL subroutine
first to clarify – “mainframe” is z/OS. If not, then the following may not apply. Dynamic allocation aside, the module (called or main) that defines the file and opens it and closes it really needs to be the one that reads it. In order to have 2 different modules operating on the file will require [...]
View Answer
| February 22, 2010 6:29 PM
COBOL, Dynamic file allocation, Mainframe programming
first to clarify – “mainframe” is z/OS. If not, then the following may not apply. Dynamic allocation aside, the module (called or main) that defines the file and opens it and closes it really needs to be the one that reads it. In order to have 2 different modules operating on the file will require [...]
View Answer
| February 22, 2010 6:29 PM
COBOL, Dynamic file allocation, Mainframe programming
high-values low-values (microfocus COBOL in Oracle/Linux environment)
How about a working storage field named MY-HIGH-VALUE with a length of 9 and fill it with x’FF’ during program house keeping. ALL (and I mena ALL) other programs will also have to do this. I don’t know MicroFocus COBOL, but I just have to wonder why it thinks x’07′ is HIGH VALUES. Maybe some [...]
View Answer
| February 22, 2010 6:16 PM
COBOL, Linux, Oracle Database
How about a working storage field named MY-HIGH-VALUE with a length of 9 and fill it with x’FF’ during program house keeping. ALL (and I mena ALL) other programs will also have to do this. I don’t know MicroFocus COBOL, but I just have to wonder why it thinks x’07′ is HIGH VALUES. Maybe some [...]
View Answer
| February 22, 2010 6:16 PM
COBOL, Linux, Oracle Database
NDM ConnectDIrect Documentation needed!
Here is some<a href=”http://www.sterlingcommerce.com/products/managed-file-transfer/connect-direct/”> reference stuff</a> from Sterling Conference
View Answer
| February 22, 2010 3:46 PM
Connect:Direct, NDM
Here is some<a href=”http://www.sterlingcommerce.com/products/managed-file-transfer/connect-direct/”> reference stuff</a> from Sterling Conference
View Answer
| February 22, 2010 3:46 PM
Connect:Direct, NDM
How to findout iseries AS/400 server’s IPL status?
There is a System Value, QABNORMSW, Previous end of system indicator, that tells you whether it was normal or abnormal. This can be viewed with WRKSYSVAL, or used in a CLP with RTVSYSVAL. Hope this helps, Bill ========================================================== What <i>IPL status</i> are you thinking of? Are you trying to see if an IPL has completed [...]
View Answer
| February 21, 2010 4:38 AM
AS/400, IPL, iSeries
There is a System Value, QABNORMSW, Previous end of system indicator, that tells you whether it was normal or abnormal. This can be viewed with WRKSYSVAL, or used in a CLP with RTVSYSVAL. Hope this helps, Bill ========================================================== What <i>IPL status</i> are you thinking of? Are you trying to see if an IPL has completed [...]
View Answer
| February 21, 2010 4:38 AM
AS/400, IPL, iSeries
Upgrade clean-up procedure for backup and restore
If you don’t want to do a full restore, then remove all user libs and IFS folders then restore user profiles again then all of the user libs, IFS and documents if you use them. I would also use go cleanup and change the options to number of days to keep to 1 then make [...]
View Answer
| February 19, 2010 7:43 PM
AS/400, Backup and Recovery on Iseries, IBM 570, Upgrades, V5R4M5
If you don’t want to do a full restore, then remove all user libs and IFS folders then restore user profiles again then all of the user libs, IFS and documents if you use them. I would also use go cleanup and change the options to number of days to keep to 1 then make [...]
View Answer
| February 19, 2010 7:43 PM
AS/400, Backup and Recovery on Iseries, IBM 570, Upgrades, V5R4M5
AS/400 – Don’t prompt me for user/pass when starting 5250 emulator
The 5250 SDLC access is for interactive access – so it’s predicated on there being a person in front of the glass. You don’t want real people getting to your data without authorisation, so it wants a user id and password. Maybe you need to rethink the data access route and get the data you [...]
View Answer
| February 17, 2010 8:44 AM
5250 session, AS/400, Emulators, Green Screen, OS/400, windows credential, WS
The 5250 SDLC access is for interactive access – so it’s predicated on there being a person in front of the glass. You don’t want real people getting to your data without authorisation, so it wants a user id and password. Maybe you need to rethink the data access route and get the data you [...]
View Answer
| February 17, 2010 8:44 AM
5250 session, AS/400, Emulators, Green Screen, OS/400, windows credential, WS
“I/O Error 123″
That error usually means that a program is trying to access a file, but the directory or file name is incorrect. More details would be needed to try to provide more help (OS, application, how did the problem start, etc)
View Answer
| February 16, 2010 8:08 PM
I/O Error 123, I/O errors
That error usually means that a program is trying to access a file, but the directory or file name is incorrect. More details would be needed to try to provide more help (OS, application, how did the problem start, etc)
View Answer
| February 16, 2010 8:08 PM
I/O Error 123, I/O errors
Multiple databases on a server – SQL
There shouldn’t be any problem having them on the same physical server as long as you don’t have them both trying to listen on the same TCP port.
View Answer
| February 15, 2010 5:34 PM
PostgreSQL, SQL, SQL Database, SQL Server databases
There shouldn’t be any problem having them on the same physical server as long as you don’t have them both trying to listen on the same TCP port.
View Answer
| February 15, 2010 5:34 PM
PostgreSQL, SQL, SQL Database, SQL Server databases
