Cloning C and G drives on Windows Server 2008
I need to clone my C drive and G drive on a Windows server 2008. The C drive is a mirror and the G drive is a 6 disk raid 5. What is my best option for cloning this setup?
Answer Question
| October 21, 2011 6:11 PM
C drive, Clone database, RAID 5, Windows Server 2008
I need to clone my C drive and G drive on a Windows server 2008. The C drive is a mirror and the G drive is a 6 disk raid 5. What is my best option for cloning this setup?
Answer Question
| October 21, 2011 6:11 PM
C drive, Clone database, RAID 5, Windows Server 2008
Dell PowerEdge 6800 drives in array corrupted
We have a used Dell Power Edge 6800. The two drives in array 0 (the mirrored boot drives) keep getting corrupted. I tried different drives and the same issue. The drives are fine in other slots. Can this be a chassis issue?
Answer Question
| June 9, 2011 5:27 PM
Arrays, Corrupt Database, Dell PowerEdge, Dell PowerEdge Performance
We have a used Dell Power Edge 6800. The two drives in array 0 (the mirrored boot drives) keep getting corrupted. I tried different drives and the same issue. The drives are fine in other slots. Can this be a chassis issue?
Answer Question
| June 9, 2011 5:27 PM
Arrays, Corrupt Database, Dell PowerEdge, Dell PowerEdge Performance
Free IT Book: The Data Warehouse Mentor
The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He’ll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered [...]
Answer Question
| June 8, 2011 12:43 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
The Data Warehouse Mentor by Robert Laberge will show you how to plan, design, construct, and administer an integrated end-to-end DW/BI solution. He’ll explain how to choose appropriate components, build an enterprise data model, configure data marts and data warehouses, establish data flow, and mitigate risk. Change management, data governance, and security are also covered [...]
Answer Question
| June 8, 2011 12:43 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Restoring a backup from Brightstor 12 server
Can we restore a backup from a Brightstor 12 server without the database? What would be the procedure for that?
Answer Question
| June 7, 2011 2:29 PM
Backup, BrightStor, BrightStor ARCserve Backup 12, Database Backup, Database backup and recovery
Can we restore a backup from a Brightstor 12 server without the database? What would be the procedure for that?
Answer Question
| June 7, 2011 2:29 PM
Backup, BrightStor, BrightStor ARCserve Backup 12, Database Backup, Database backup and recovery
AS/400 tab text delimited format of physical file
Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X’05′ or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.
Answer Question
| June 17, 2011 6:06 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Hi , Using i series utility you can download PF as Text Tab Delimited format in your PC.However when I do the same by CLP using CPYTOIMPF using FLDDLM as X’05′ or *tab , I get a text tab delimited file which is not completely same as the file downloaded using I series utility.
Answer Question
| June 17, 2011 6:06 AM
AS/400, AS/400 Database File, CLP, CPYTOIMPF, Database Files, DBF file
Is there a timestamp on an Outlook rule?
I am trying to determine when an Outlook rule was set up and wanted to know how to find out
Answer Question
| June 14, 2011 2:33 AM
Exchange 2003, Outlook Rule, Outlook 2007, Outlook 2007 rules, Outlook rules, Timestamp
I am trying to determine when an Outlook rule was set up and wanted to know how to find out
Answer Question
| June 14, 2011 2:33 AM
Exchange 2003, Outlook Rule, Outlook 2007, Outlook 2007 rules, Outlook rules, Timestamp
Free IT Book: Building Applications in the Cloud
This week’s free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer’s guide to help you not just migrate to the cloud, but “use cloud architectural patterns that deliver superior performance, scalability, and availability.” Whether you’re building a new cloud solution or adapting code that already exists, this is a [...]
Answer Question
| June 2, 2011 1:35 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week’s free IT book, Building Applications in the Cloud: Concepts, Patterns, and Projects, is Christopher Moyer’s guide to help you not just migrate to the cloud, but “use cloud architectural patterns that deliver superior performance, scalability, and availability.” Whether you’re building a new cloud solution or adapting code that already exists, this is a [...]
Answer Question
| June 2, 2011 1:35 PM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, Cloud computing books, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Access 2007 database query question
I have imported a 2007 excle spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd [...]
Answer Question
| August 17, 2011 11:39 AM
Access 2007, Access 2007 functions, Access Database, Access query, QuerySave
I have imported a 2007 excle spread sheet. There are mutible columns that have date information. I need two types of gueries. First query to look at one column and only list records that have todays date, previous dates and dates through 7 days in the future. the query also need to reference a 2nd [...]
Answer Question
| August 17, 2011 11:39 AM
Access 2007, Access 2007 functions, Access Database, Access query, QuerySave
Numeric or Value Error for string aggregation
Hi, I use below code for string aggregation. My database table which I apply string aggregation is a large one with 165 million rows. Although I use CLOB, I get numeric or value error in eggregation termination function after the script is run for a long time. For a small table, I do not get [...]
Answer Question
| May 27, 2011 1:57 PM
CLOB, CLOB Problem, String testing
Hi, I use below code for string aggregation. My database table which I apply string aggregation is a large one with 165 million rows. Although I use CLOB, I get numeric or value error in eggregation termination function after the script is run for a long time. For a small table, I do not get [...]
Answer Question
| May 27, 2011 1:57 PM
CLOB, CLOB Problem, String testing
Oracle fails due to disk partition is full. Data now is corrupted.
Hi all, I have a big trouble with one application that is working in a wrong way due to Oracle failure. Oracle is running on AIX. I just have access to see the disk partitions on the server with df command but I have no access to see Oracle logs. I can see that one [...]
Answer Question
| May 26, 2011 5:06 PM
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors
Hi all, I have a big trouble with one application that is working in a wrong way due to Oracle failure. Oracle is running on AIX. I just have access to see the disk partitions on the server with df command but I have no access to see Oracle logs. I can see that one [...]
Answer Question
| May 26, 2011 5:06 PM
AIX, Corrupted database, Oracle, Oracle Database, Oracle database administration, Oracle error messages, Oracle errors
You Pick: Drupal’s Building Blocks, Scalability Rules, Building Cloud Apps, DTrace
This week, you get your pick of our most recent IT book titles. Check out our latest titles in the IT Bookworm Blog for more details on these books: Scalability Rules Multicore Application Programming Drupal’s Building Blocks Building Applications in the Cloud DTrace To win one of these great resources, answer a question from the [...]
Answer Question
| May 25, 2011 5:22 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
This week, you get your pick of our most recent IT book titles. Check out our latest titles in the IT Bookworm Blog for more details on these books: Scalability Rules Multicore Application Programming Drupal’s Building Blocks Building Applications in the Cloud DTrace To win one of these great resources, answer a question from the [...]
Answer Question
| May 25, 2011 5:22 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
AS400 Shell command
Hi Iam using jar command to comprees the csv file to Zip file.in my program.iam submitting the job,usually it oftens fails for few files to zip.it gives me the error like qsh: 001-0012 Error found starting child process. System resources not available to complete request. So how can i solve this issue within in my [...]
Answer Question
| May 24, 2011 11:54 AM
AS/400 CSV, AS400 - STRQSH, AS400 Shell command, CSV, Shell commands
Hi Iam using jar command to comprees the csv file to Zip file.in my program.iam submitting the job,usually it oftens fails for few files to zip.it gives me the error like qsh: 001-0012 Error found starting child process. System resources not available to complete request. So how can i solve this issue within in my [...]
Answer Question
| May 24, 2011 11:54 AM
AS/400 CSV, AS400 - STRQSH, AS400 Shell command, CSV, Shell commands
Contest Bounty: Ask/Answer questions this weekend, earn 100 points!
Is the rain keeping your weekend plans from getting off the ground? Well, IT Knowledge Exchange has a chance for you to take advantage of staying indoors. Ask or answer 10 questions* this weekend, and you will earn 100 knowledge points, good for our current contest! Any combination of asking/answering is acceptable. Post the links [...]
Answer Question
| May 20, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Is the rain keeping your weekend plans from getting off the ground? Well, IT Knowledge Exchange has a chance for you to take advantage of staying indoors. Ask or answer 10 questions* this weekend, and you will earn 100 knowledge points, good for our current contest! Any combination of asking/answering is acceptable. Post the links [...]
Answer Question
| May 20, 2011 3:50 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT answers, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Free IT Book: Governing Shared Services On-Premise and in the Cloud
This week’s free IT book is from Prentice Hall: SOA Governance: Governing Shared Services On-Premise and in the Cloud. From the publishers: “[This book] is the result of a multi-year project to collect proven industry practices for establishing IT governance controls specific to the adoption of SOA and service-orientation….[It] steps the readers through the most [...]
Answer Question
| November 30, 2011 4:04 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
This week’s free IT book is from Prentice Hall: SOA Governance: Governing Shared Services On-Premise and in the Cloud. From the publishers: “[This book] is the result of a multi-year project to collect proven industry practices for establishing IT governance controls specific to the adoption of SOA and service-orientation….[It] steps the readers through the most [...]
Answer Question
| November 30, 2011 4:04 PM
AS/400, Business Intelligence, Channel, CIO, CRM, Database, DataCenter, Development, Exchange, Giveaways, IT Books, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, SAP, Security, SQL Server, Storage, twitter, Virtualization, VoIP, Windows Server
Central remote desktop using Windows Server 2008?
We want to do away with all of our one to one nats into our datacenter. Can we have a central remote desktop server using Windows server 2008 and if so what do we need to do to get it working/configured?
Answer Question
| May 16, 2011 2:12 PM
NAT, Networking, One-to-One Relationships, Remote Desktop Connection, Remote desktop management, Windows Server 2008, Windows Server 2008 Administration
We want to do away with all of our one to one nats into our datacenter. Can we have a central remote desktop server using Windows server 2008 and if so what do we need to do to get it working/configured?
Answer Question
| May 16, 2011 2:12 PM
NAT, Networking, One-to-One Relationships, Remote Desktop Connection, Remote desktop management, Windows Server 2008, Windows Server 2008 Administration
How to make the connection in SQL 2000 with Visual Basic 6
i want to make the sql connection with vb6,how to open the connection in sql
Answer Question
| May 16, 2011 2:26 AM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
i want to make the sql connection with vb6,how to open the connection in sql
Answer Question
| May 16, 2011 2:26 AM
SQL 2000, SQL connection, SQL connectivity, VB, VB.NET, Visual Basic 6
Completed IT Knowledge Exchange Profile? Earn points!
What’s a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward our current contest! [...]
Answer Question
| May 18, 2011 2:26 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
What’s a community without a face? Let your fellow IT Knowledge Exchange members know a little more about you and your expertise by filling out your public profile and uploading a photo. Then put the link to your profile in the discussion area below to claim your 10 knowledge points, good toward our current contest! [...]
Answer Question
| May 18, 2011 2:26 PM
AS/400, Business Intelligence, Channel, CIO, Contests, CRM, Database, DataCenter, Development, Exchange, ITKE, ITKE Community, Knowledge Point Bounty, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Oracle, Profile Pictures, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Embedded SQLRPGLE Books, guides, how to’s
Does anyone know of some good SQL books for RPGLE other than the IBM manuals? I need to learn more to keep afloat!
Answer Question
| May 11, 2011 6:33 PM
Embedded SQL, IT Books, Open IT Forum, Reference Guides, SQLRPGLE Books
Does anyone know of some good SQL books for RPGLE other than the IBM manuals? I need to learn more to keep afloat!
Answer Question
| May 11, 2011 6:33 PM
Embedded SQL, IT Books, Open IT Forum, Reference Guides, SQLRPGLE Books
Embedded SQL in RPGLE hdr, dtl fetch for subfile build
I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr E DS EXTNAME(wtchdr) D dswtcdet E DS EXTNAME(wtcdet) C $CreateCsr Begsr C/EXEC SQL C+ prepare S1 from :sqlstmt C/end-exec * C/EXEC SQL C+ declare C1 scroll cursor for S1 C/end-exec C EndSr [...]
Answer Question
| May 12, 2011 4:46 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE
I am trying to join a header and a detail file and select all fields into data structures defined as external(filename). D dswtchdr E DS EXTNAME(wtchdr) D dswtcdet E DS EXTNAME(wtcdet) C $CreateCsr Begsr C/EXEC SQL C+ prepare S1 from :sqlstmt C/end-exec * C/EXEC SQL C+ declare C1 scroll cursor for S1 C/end-exec C EndSr [...]
Answer Question
| May 12, 2011 4:46 PM
AS/400 Subfiles, Embedded SQL, Header, SQL Server, SQLRPGLE
Can we change length of CSV File
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]
Answer Question
| May 11, 2011 11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
Hi guys, I have a CSV format file in my database which is used for Adhoc reporting. Now, I need to increase the legnth of that file. I am trying to increase using CHGPF command, But I wasnt able to do the same. Will any one of you suggest me the way for increasing the [...]
Answer Question
| May 11, 2011 11:22 AM
AS/400, AS/400 DB2, CHGPF, CSV, CSV file format
