Provide outside access in a workgroup
My wife has a similar requirement (also under HIPAA), and Sharefile.com was a good solution. With audit trails, it is easy to find out who accessed files and when, even receiving alerts for file uploads and downloads. They offer a Sync feature that could help you manage the external aspect.
View Answer
| September 28, 2011 9:01 PM
Shared folders, Terminal Services, VPN security, Workgroup
My wife has a similar requirement (also under HIPAA), and Sharefile.com was a good solution. With audit trails, it is easy to find out who accessed files and when, even receiving alerts for file uploads and downloads. They offer a Sync feature that could help you manage the external aspect.
View Answer
| September 28, 2011 9:01 PM
Shared folders, Terminal Services, VPN security, Workgroup
What is the best why to get started in DBA
I was in about the same situation when our System Admin/DBA left and I just inherited the job. That is a stressful way to start, but I learned fast. I did eventually get some training through an IBM business partner – after I had already done it for awhile. That actually makes sense from the [...]
View Answer
| September 28, 2011 8:06 PM
Access, DBA training, iSeries database, SQL
I was in about the same situation when our System Admin/DBA left and I just inherited the job. That is a stressful way to start, but I learned fast. I did eventually get some training through an IBM business partner – after I had already done it for awhile. That actually makes sense from the [...]
View Answer
| September 28, 2011 8:06 PM
Access, DBA training, iSeries database, SQL
ODBC problem Changing Structure Table
When I have run into this issue I’ve been using interface software used to create a list of tables (like MS Access or Eclipse) for the client application. In those cases, I’ve needed to delete the table from the list, open the interface to the ODBC driver, and then re-select updated the table(s) to refresh [...]
View Answer
| September 28, 2011 7:08 PM
DDS, ODBC, V5R3
When I have run into this issue I’ve been using interface software used to create a list of tables (like MS Access or Eclipse) for the client application. In those cases, I’ve needed to delete the table from the list, open the interface to the ODBC driver, and then re-select updated the table(s) to refresh [...]
View Answer
| September 28, 2011 7:08 PM
DDS, ODBC, V5R3
Getting the number of deleted records from Physical file
Use the DSPFD command with TYPE(*MBRLIST) OUTPUT(*OUTFILE) Then you can use SQL, Query, or a program to get the information
View Answer
| September 28, 2011 6:29 PM
AS/400, AS400 physical file, DSPFD, Physical Files
Use the DSPFD command with TYPE(*MBRLIST) OUTPUT(*OUTFILE) Then you can use SQL, Query, or a program to get the information
View Answer
| September 28, 2011 6:29 PM
AS/400, AS400 physical file, DSPFD, Physical Files
Using Dropbox and Radio button with DB2400
No DB2 is a database IBMi aka i series aka As/400 provides all the tools you need to use whatever data presentation takes your fancy.
View Answer
| September 28, 2011 7:24 AM
AS/400 DB2, DB2/400, Dropbox, Radio buttons
No DB2 is a database IBMi aka i series aka As/400 provides all the tools you need to use whatever data presentation takes your fancy.
View Answer
| September 28, 2011 7:24 AM
AS/400 DB2, DB2/400, Dropbox, Radio buttons
Mass change on user profiles
run a DSPUSRPRF to an outfile, and write a function which runs a CHGUSRPRF for each record, according to what you wish to do. You will need appropriate security to do this.
View Answer
| September 28, 2011 7:07 AM
AS/400 commands, AS/400 user profiles, User profiles
run a DSPUSRPRF to an outfile, and write a function which runs a CHGUSRPRF for each record, according to what you wish to do. You will need appropriate security to do this.
View Answer
| September 28, 2011 7:07 AM
AS/400 commands, AS/400 user profiles, User profiles
Challenge improving query performance on large tables
Start by getting rid in the index scan by adding a non-clustered index. If you can post the sqlplan file somewhere I can take a look at it.
View Answer
| September 27, 2011 11:55 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2
Start by getting rid in the index scan by adding a non-clustered index. If you can post the sqlplan file somewhere I can take a look at it.
View Answer
| September 27, 2011 11:55 PM
Query optimization, Query performance, SQL query optimization, SQL Server 2008, SQL Server 2008 R2
Network Port Usage
In Windows 2008 R2 clustering really doesn’t need it’s own heartbeat network any more. I’d use those for guest iSCSI traffic.
View Answer
| September 27, 2011 11:52 PM
Engineering, Hyper-V, iSCSI SAN, NIC Ports, Windows 2008 R2
In Windows 2008 R2 clustering really doesn’t need it’s own heartbeat network any more. I’d use those for guest iSCSI traffic.
View Answer
| September 27, 2011 11:52 PM
Engineering, Hyper-V, iSCSI SAN, NIC Ports, Windows 2008 R2
Replacing antivirus protection
For best performance and a clean install I would recommend you do uninstall the old first and reboot.
View Answer
| September 27, 2011 9:04 PM
Antivirus, Antivirus software, Desktop antivirus
For best performance and a clean install I would recommend you do uninstall the old first and reboot.
View Answer
| September 27, 2011 9:04 PM
Antivirus, Antivirus software, Desktop antivirus
VSAM versus DB2 in CPU consumption
Thank you all for the comments but I was not clear about my problem description. My company has already made the decision to convert several COBOL/VSAM legacy systems to COBOL/DB2 after evaluating all their advantages and disadvantages. My job now is estimate how much we have increase the CPU to define the budget. We have [...]
View Answer
| September 27, 2011 7:44 PM
AS/400 DB2, DB2, VSAM, z/OS CPU consumption
Thank you all for the comments but I was not clear about my problem description. My company has already made the decision to convert several COBOL/VSAM legacy systems to COBOL/DB2 after evaluating all their advantages and disadvantages. My job now is estimate how much we have increase the CPU to define the budget. We have [...]
View Answer
| September 27, 2011 7:44 PM
AS/400 DB2, DB2, VSAM, z/OS CPU consumption
SQL to query a file
Here’s some sample code i just put together quick using fake information. It just shows a generic way to embed SQL in an ILE RPG program: <pre> d SalesRec DS d Salesman 25A INZ(*blanks) d TotalSales 10S 2 INZ(0) d MaxSale 10S 2 INZ(0) d MinSale 10S 2 INZ(0) ************** c/FREE //Declare a cursor for [...]
View Answer
| September 27, 2011 7:27 PM
Open Query File, RPG, SQL, SQL Query
Here’s some sample code i just put together quick using fake information. It just shows a generic way to embed SQL in an ILE RPG program: <pre> d SalesRec DS d Salesman 25A INZ(*blanks) d TotalSales 10S 2 INZ(0) d MaxSale 10S 2 INZ(0) d MinSale 10S 2 INZ(0) ************** c/FREE //Declare a cursor for [...]
View Answer
| September 27, 2011 7:27 PM
Open Query File, RPG, SQL, SQL Query
How to remove consistency check in lotus notes?
Skip_Fixup=1. If it is set in the NOTES.INI file, Notes skips the consistency checking of a database when the database is opened. This parameter should only be used with a Notes client. Or simply go to c:Program Files/lotus/notes/data/ and change perweb.nsf file to perweb.nsf.old. This starts to happen when the locally stored database gets to [...]
View Answer
| September 27, 2011 5:15 PM
Consistency Control, Database Consistency Checker, Lotus Notes, Lotus Notes administration, Lotus Notes configuration
Skip_Fixup=1. If it is set in the NOTES.INI file, Notes skips the consistency checking of a database when the database is opened. This parameter should only be used with a Notes client. Or simply go to c:Program Files/lotus/notes/data/ and change perweb.nsf file to perweb.nsf.old. This starts to happen when the locally stored database gets to [...]
View Answer
| September 27, 2011 5:15 PM
Consistency Control, Database Consistency Checker, Lotus Notes, Lotus Notes administration, Lotus Notes configuration
3PAR Software Upgrades
3PAR Support has determined that upgrade issues we experienced have been the result of incompatibilities between HBA and SAN switch firmware. ALso, most of our upgrades were disruptive. We did not have this issue with the XIV however.
View Answer
| September 27, 2011 2:15 PM
3PAR, 3PAR Software Upgrades, 3PAR Upgrades
3PAR Support has determined that upgrade issues we experienced have been the result of incompatibilities between HBA and SAN switch firmware. ALso, most of our upgrades were disruptive. We did not have this issue with the XIV however.
View Answer
| September 27, 2011 2:15 PM
3PAR, 3PAR Software Upgrades, 3PAR Upgrades
How to export windows userids ?
Hi, Your question is not pretty clear. If I am not wrong, you want to migrate user attributes. For this Please refer the article: http://technet.microsoft.com/en-us/library/dd379531%28WS.10%29.aspx Thank you Anil <a href=”http://www.lepide.com”>LEPIDE</a>
View Answer
| September 27, 2011 12:12 PM
Windows Server 2003, Windows Server 2003 administration
Hi, Your question is not pretty clear. If I am not wrong, you want to migrate user attributes. For this Please refer the article: http://technet.microsoft.com/en-us/library/dd379531%28WS.10%29.aspx Thank you Anil <a href=”http://www.lepide.com”>LEPIDE</a>
View Answer
| September 27, 2011 12:12 PM
Windows Server 2003, Windows Server 2003 administration
remote.domain name pop up opening outlook
Hi, You need to reconfigure the exchange services. Refer to the article: http://technet.microsoft.com/en-us/library/bb201695.aspx Thank you Anil <a href=”http://www.lepide.com”>LEPIDE</a>
View Answer
| September 27, 2011 11:45 AM
Exchange, Exchange 2007, SBS, Small Business Server, Small Business Server 2008
Hi, You need to reconfigure the exchange services. Refer to the article: http://technet.microsoft.com/en-us/library/bb201695.aspx Thank you Anil <a href=”http://www.lepide.com”>LEPIDE</a>
View Answer
| September 27, 2011 11:45 AM
Exchange, Exchange 2007, SBS, Small Business Server, Small Business Server 2008
Problem with roaming profiles in Windows server 2003
Hi, If the server cannot save a user’s profile because of incorrect security, this error occurs. If a user cannot be logged on by using a cached profile and is issued a temporary profile, the standard temporary profile message appears after the error message. for further details, refer the article: http://support.microsoft.com/kb/327462 Thank you Anil <a [...]
View Answer
| September 27, 2011 11:26 AM
Roaming Profiles, Windows Server 2003, Windows Server 2003 administration, Windows XP
Hi, If the server cannot save a user’s profile because of incorrect security, this error occurs. If a user cannot be logged on by using a cached profile and is issued a temporary profile, the standard temporary profile message appears after the error message. for further details, refer the article: http://support.microsoft.com/kb/327462 Thank you Anil <a [...]
View Answer
| September 27, 2011 11:26 AM
Roaming Profiles, Windows Server 2003, Windows Server 2003 administration, Windows XP
Crystal Reports XI reports
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:10 AM
Crystal Report XI, Crystal Reports, Windows Server 2003
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:10 AM
Crystal Report XI, Crystal Reports, Windows Server 2003
Open IT Forum: Will HP be a worthy cloud contender?
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:01 AM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Good luck with the book,everyone always brings this up! Enjoy http://www.nikemallchina.com, Retail and wholesale NIKE、Adidas’s running shoes, soccer shoes, basketball shoes,and so on.
View Answer
| September 27, 2011 8:01 AM
AS/400, Business Intelligence, Channel, CIO, Cloud Computing, CRM, Database, DataCenter, Development, Exchange, Hewlett-Packard, HP, Linux, Lotus Domino, Microsoft Windows, Mobile, Networking, Open IT Forum, Oracle, SAP, Security, SQL Server, Storage, Virtualization, VoIP, Windows Server
Move aof an EMC Clariion with Mirrorview
You’ll want to pause or stop the mirrors when you take down the array, then bring it back up after the move once you are sure the link is up and stable. I assume that the array will only be down for a night so the resync shouldn’t be that bad. If possible keep the [...]
View Answer
| September 26, 2011 9:03 PM
CLARiiON storage systems, EMC CLARiiON, MirrorView
You’ll want to pause or stop the mirrors when you take down the array, then bring it back up after the move once you are sure the link is up and stable. I assume that the array will only be down for a night so the resync shouldn’t be that bad. If possible keep the [...]
View Answer
| September 26, 2011 9:03 PM
CLARiiON storage systems, EMC CLARiiON, MirrorView
SSRS authentication in workgroup environment
Users won’t be able to authenticate automatically in a workgroup. The server must prompt them for credentials, and the credentials that they enter much be users created on the server which is running SSRS.
View Answer
| September 26, 2011 6:47 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups
Users won’t be able to authenticate automatically in a workgroup. The server must prompt them for credentials, and the credentials that they enter much be users created on the server which is running SSRS.
View Answer
| September 26, 2011 6:47 PM
Reporting Services, Reporting Services Configuration Manager, SSRS, Windows 7, Workgroup Servers, Workgroups
